I have urls listed in column N. Eventually there will be a few hundred that I would like to open in sequence and return data to the same range in excel. I will then manipulate that data and store in another part of the workbook or save each to a modified HTML file. The problem I am having is that when I copied the individual urls from the list in the site's root directory I get this format
AQU130104.HTM
When I click on it in excel it does take me where I want to go to the correct page on the site. The full path is.....
http://www.racingchannel.com/archive.../AQU130104.HTM
How can I move down column N opening each page in a web query sequentially and return data to excel? I am not familiar with code for opening web queries.
Thanks Harry
Bookmarks