Macro to copy active worksheet from multiple Excel files into 1 fi
 

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.

Macro to copy active worksheet from multiple Excel files into 1 fi
 

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.

Macro to copy active worksheet from multiple Excel files into
 

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.

Macro to copy active worksheet from multiple Excel files into
 

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.

Macro to copy active worksheet from multiple Excel files into
 

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.

Macro to copy active worksheet from multiple Excel files into
 

Your Welcome

Macro to copy active worksheet from multiple Excel files into 1 fi
 

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.