Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query - Unable to Record
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UNABLE TO RECORD A MACRO | Excel Worksheet Functions | |||
Unable to record Macro | Excel Discussion (Misc queries) | |||
Unable to Record Macro | Excel Discussion (Misc queries) | |||
Unable to Record Macro | Excel Discussion (Misc queries) | |||
Unable to record macro | Excel Discussion (Misc queries) |