Inserting Sheets from multiple files
 

I am trying to find out if it is possible to take the 1st sheet from multiple workbooks in a directory (ie. C:\data) and append them into the first sheet of a single workbook?

Thanks,

Fred

Inserting Sheets from multiple files
 

There is no built-in Excel tool to do this. You could write a macro to do
it of course. Sorry I do not have an example.


--
Jim
"fgwiii" wrote in message
...
|
| I am trying to find out if it is possible to take the 1st sheet from
| multiple workbooks in a directory (ie. C:\data) and append them into
| the first sheet of a single workbook?
|
| Thanks,
|
| Fred
|
|
| --
| fgwiii

Inserting Sheets from multiple files
 

Try he-

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"fgwiii" wrote in message
...

I am trying to find out if it is possible to take the 1st sheet from
multiple workbooks in a directory (ie. C:\data) and append them into
the first sheet of a single workbook?

Thanks,

Fred


--
fgwiii