Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages

[Martin]

Hello,

I'm currently involved in a project in which I'm *individually* saving (Save
As) a live HTML web page before converting it to an Excel spreadsheet.

I save 22 individual, though identically formatted, web pages which I then
convert to spreadsheets, each separate from the other by virtue of being in
its own workbook.

I would like to know the following: Is it possible, whether before or after
converting the web pages to 22 individual Excel spreadsheets, to add/merge
them in the same workbook so that I'm required to open only 1 and not 22
workbooks? If so, how?

I'm using Office 2002 Professional.

Any and all assistance from this NG is greatly appreciated.

Cordially,

Martin

 

[Barb Reinhardt]

I'm betting you can find some code to do what you want here

http://www.rondebruin.nl/tips.htm