Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Migration from Excel 2000 to 2003 | Excel Programming | |||
Excel 2000 to 2002 - #NAME? | Excel Discussion (Misc queries) | |||
Excel 2000 to 2002 - #NAME? | Excel Discussion (Misc queries) | |||
Excel2000/2002 migration problem | Excel Discussion (Misc queries) | |||
Excel 2000 and 2002 | Excel Programming |