QueryTables - Excel 2000 to 2002 migration

[[email protected]]

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">&nbsp;</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

[Phil_V]

If anyone can take a look I would, appreciate it, this is the query that doesn't work for me under Excel XP, but works fine under 2000:

Please Login or Register  to view this content.

Thanks all,

Phil

[Phil_V]

No ideas??

Anyone??

Phil