I have a list of several hundred URLs in Excel. The URLs are all from the same site and have the same format and structure, but the specific data on the page varies. There are 3 specific pieces of information from each resulting web page that I would like to capture in an Excel worksheet. I am hopeful that there is a way to do this using VB, but I have not been able to get it to work.
I have successfully used a Web Query for one of the URLs from my list, identified the appropriate table (table 9), imported the data from that URL into Excel, identified the 3 fields I would like to copy (A2, A3, B5) and pasted that data into a new "results" worksheet. But now I need an automated solution that will look up the next URL in the list, run the Web Query and copy the contents of the three cells into the next row of the results worksheet, then move on to the next URL, etc.
Does anyone have any pointers how to do this? Or perhaps a better way to accomplish this than using VB? Thanks for your help!
Bookmarks