Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Adding Lines to Linked Spreadsheets 1
Copy formulas from one workbook to another 1
Importing Data from Multiple spreadsheets to one 1
Collate data from multiple workbooks into one worksheet 0
Would like to remove active content from Docs saved to HTML 1
Printing multiple pages on one individual from an Access Report 1
Consolidate Excel Data from multiple sheets into one 1
Opening excel spreadsheets via excel.application object w/o prompts 2

Top