Combine Multiple Spreadsheets

I have about 200 separate spreadsheet files that I need
to combine into one. Other than copying and pasting I
don't know how to do this. Can it even be done?
Thanks,
Cory

With a macro, it can be done.

To give you any needed help with that requires precise information about the layout (presumably
they are all the same?), how you want them combined (onto 1 sheet, multiple sheets in one
book?), where the 200 files are located, etc.

On Tue, 7 Oct 2003 11:38:43 -0700, "CCourtois" wrote:

I have about 200 separate spreadsheet files that I need
to combine into one. Other than copying and pasting I
don't know how to do this. Can it even be done?
Thanks,
Cory

Open a new workbook and the spreadsheet(s) that you want
to combine. Right click on the sheet tab and select Move
or Copy. Indicate which book (probably the new workbook)
you wamt to copy the sheet to, where you want it, and
REMEMBER to check off "Create a Copy" if you want the
sheet to remain in the original file.


-----Original Message-----
I have about 200 separate spreadsheet files that I need
to combine into one. Other than copying and pasting I
don't know how to do this. Can it even be done?
Thanks,
Cory
.

Try this example

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

Post back if you need help

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"CCourtois" wrote in message ...
I have about 200 separate spreadsheet files that I need
to combine into one. Other than copying and pasting I
don't know how to do this. Can it even be done?
Thanks,
Cory