phil_valentine@hotmail.com
Guest
QueryTables - Excel 2000 to 2002 migration
Hi, I'm hoping someone here can help.
I have some vba code that I wrote to retreive data from a web page. I
wrote it using QueryTables when I had Excel 2000 installed and all is
happy.
However I have now upgraded to Excel 2002 and when the code doesn't
work.
To start debugging I tried to get the QueryTable manually and it
doesn't work. Instead I get the following error:
File cannot be opened because:
Reference to undefined entity 'nbsp'.
Line 83, Position 52.
<td align="top" rowspan="3" width="40"> </td>
[OK]
If I click on the OK button the webpage is then loaded with the html
code for the webpage, rather than the table I tried to import.
If I uninstall Excel 2002 and reinstall Excel 2000 then the query runs
fine, so I know nothing has changed on the webpage. My question is has
something changed in the way that Excel now access the Query?
Any suggestions anyone?
Thanks,
Phil
Bookmarks