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