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

V

Versace77

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.
 
V

Versace77

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.
 
V

Vijay Chary

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
 
Top