Copy worksheet from multiple files in one DIR to another DIR & rename

M

Mike Taylor

Can anyone share idea(s) for code that will programatically loop
through all the .xls files in a directory and copy the second sheet
all the .xls files in the "C:\My Documents\Data\month01" directory to
a workbook named "tot01.xls" [path is "C:\My
Documents\Data\Consol\tot01.xls"] and then name each sheet copied
using the value in cell C2 of each of the sheets after it is copied?
Any ideas are greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i loop thru all the worksheets in 2 files one by one 0
Macro to copy files from Folders/Subfolders 3
How to code it in macro? 0
Open Files in Folder 2
How to code it in macro? 2
VBA - exporting serial letters to single documents 0
Move all except latest to another folder 2
Copy range from multiple files in multiple folders to single sheet in master WB 10

Top