ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need Help on Web Query - Thanks in Advance (https://www.excelbanter.com/excel-programming/301812-need-help-web-query-thanks-advance.html)

Jim[_27_]

Need Help on Web Query - Thanks in Advance
 
I have done several web Queries by recording them
and then edting the VB code to customize it. I recently
tried the same thing and received the message of
"unable to record" from Excel. I am using Excel 2003
and the web site I went to was:
www.realyellowpages.com

I went to the above listed URL and selected the
category of "apartments" in the City of "Gainesville"
Florida. I clicked on Find it and I saw my first page
of data. I selected each table by clicking each one.
I then clicked on the import button and selected
the default setting range of A1. When I clicked OK
again I recieved the "Unable to record" message
from Excel. When I check the VBE there is no
code in the routine I tried to record.

Even though there was no code the data from
the URL was placed in the active worksheet.

Anyone else have this problem? Anyone know
how to get Excel to record the code for this
web query?

Thanks,
Jim


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com