Importing Multiple External Web Data (Same site, slightly altered URLs stored in a sheet).

Hi,

I had a question that I searched for and did not really find a thread with answers for, although I admittedly did not dig very deeply into the archives.

My situations is as such:

I have a spreadsheet with about 170 URLs that are rather long. They are all in column A and listed with no other columns containing data. These URLs link to the results page of a search query on a textbook site: The search queries are all the same except for three variables, namely: "department," "class number" and "section". Thus, the URLs look something like this:

bookstore.com/department=????&course=???&section=???

The 170 URLs in this spreadsheet are all variations of this but contain the appropriate values for "department", "course" and "section". Thus, the first to URLs might looks like this:

bookstore.com/department=MATH&course=101&section=003
bookstore.com/department=BIOL&course=201&section=040

What I am trying to do is get external data from each of these URLs and place them in a different sheet. The URLs described above all point to the same table and format but with different results (required textbooks) that I want to record, so selecting the table with each data importation is not a issue because they are all the same table.

Does anyone have any suggestions as to how I should approach this? I have read that recording a data from the web query as a macro and then modifying its VBA code is a good way to go, but not only do I can an error message about "unable to record," but I also would later have trouble creating iterations that use the different variables values for each query contained in my spreadsheet of differing URLs.

Thanks,

adambk

That gave me some ideas but I have figured out the vba code to import a single, entire, page for the first url:

Please Login or Register  to view this content.

What I now need to do is create a loop where the macro will query all 180 urls that I have stored in sheet one of the same workbook, and for each iteration of the new query to copy the data into a new sheet (numbered 1 - 180) in the same workbook

Can anyone help? This shouldn't be too hard hopefully...

Thanks