How to do multiple Web Imports into a single Worksheet

Hi Guys,

I have a task that I need to complete but I can't find how to get done. I've searched but I can't find anything that suits my needs. I'm new to Macros and I have't a clue about VBA

I have an a site on our companies intranet that has a list of modules broken up into subpages (i.e 0, A-Z). I need to import the content of those subpages into a single Excel worksheet.

The web addresses are all similar except they increment alphabetically at the end :-

http://.......0.htm
http://.......a.htm
http://.......b.htm
etc

The problem I'm having is looping the imports and adding them to the blank part of the same worksheet

Any help would be greatly appreciated!!

thanks

Wess..

You could select locations on a blank worksheet and use the Excel Web Query function :
<Data><Import External Data><New Web Query>

Find a cell for the location of the upper-left corner of the block of data you want.
Using the Excel draw-down menus select the options above. (This will open a small window to your web browser.)
Navigate to the web page with the data you need and click on the pointer(You will see them on this temporary window) that selects the data block you need.
Now you can click on the import button at the bottom of the window.
You will be prompted for options that are self explaining, but read them carefully.

This will import the selected data from the web into your spreadsheet.
You can create multiple Import by simply selecting the target cell prior to creating the new Web Query.
These queries can then be updated with VBA by selecting the target cell and using the statement

Selection.QueryTable.Refresh BackgroundQuery:=False

or you can simply click on the Refresh All icon on the Excel "External Data" tool bar.