Turn on the macro recorder

open each in excel.

Bring the data from workbooks 2 and 3 into workbook 1 using copy and paste.

Save as HTML

Turn off the macro recorder.

Now modify the code to make it a little more dynamic.

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
I am using Office 2003 on Windows XP.

Take one Excel file that has been converted (saved as) an HTML document
from
one user. Take another one from another user, and yet a third one.

I need to combine these into one single HTML document programmatically
from
VBA. Is this possible? I've been looking at previous posts and I don't see
anything like this...

For the most part the files just contain text and numbers or formulas, but
rarely could include a chart or other graphic.

If it is possible, could some one please post example code?

If it is NOT possible, could someone please enlighten me?
Thanks much in advance.