Good evening,

This may be on the forums already but i must be searching for it wrong if it
is.

A daily Excel file is placed into a folder. I'd like to have the worksheet
from all the files within that folder to be copy/pasted into a new workbook.

Example, each file has a worksheet named ABCcurrent date. I want the new
file/workbook to contain it all, ABC092208, ABC092308, ABC092408, etc. This
would save alot of manual labor.

Thank you for any support you can provide.

G'day Versace

Here's what you need:

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

Copy/paste the code into a module and change to suit.

HTH
Mark.

Mark, thanks for the quick reply.

After looking at the link you provided I think it's focusing on something
different. The link shows how to 'create a workbook from every sheet in your
workbook'.

I'm looking at having the active sheet from many many workbooks located in
one folder copied into a new workbook so that i now have one workbook
containing all the sheets that were located, separately in the other folder.

Example: Folder C:\Data contained 50 Excel files. Each excel file contains
1 worksheet title ABCcurrentdate. I'm looking for a macro to open or copy
each of the 50 worksheets from the 50 files and place them into 1 new
workbook so that this new work book now contains 50 sheets.

Again, thanks Mark for your reply.

Many thank to anyone that can assist.

"NoodNutt" wrote:

G'day Versace

Here's what you need:

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

Copy/paste the code into a module and change to suit.

HTH
Mark.

Oops!

If, as you say each workbook contains the same you want to copy into 1 then
go for this one

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

Regards
Mark.

Very cool Mark, thanks for the assist!

Mike

"NoodNutt" wrote:

Oops!

If, as you say each workbook contains the same you want to copy into 1 then
go for this one

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

Regards
Mark.

Your Welcome

Hi Versace !! :)
You can open all the daily Excel files in your
folder, if you know the file names.The rest of the solution is rather simple.
You can copy-move the particular sheets fromall the files to your new
workbook. This is done by checking all the sheets in the daily Excel file to
find the sheet to copy.

I hope this will help you !

Vijay

"Versace77" wrote:

Good evening,

This may be on the forums already but i must be searching for it wrong if it
is.

A daily Excel file is placed into a folder. I'd like to have the worksheet
from all the files within that folder to be copy/pasted into a new workbook.

Example, each file has a worksheet named ABCcurrent date. I want the new
file/workbook to contain it all, ABC092208, ABC092308, ABC092408, etc. This
would save alot of manual labor.

Thank you for any support you can provide.