Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages
 

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

Adding Multiple Excel Spreadsheets To One Another From Saved HTML
 

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

http://www.rondebruin.nl/tips.htm
--
HTH,
Barb Reinhardt



"Martin" wrote:

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