Combining Workbooks using VBa

Jons

New member
Joined
May 8, 2014
Messages
1
Reaction score
0
Points
0
Hi Guys.

I need help with VBA code to combine workbooks.

I have 14 workbooks named 1.00, 1.01, ... .., 1.13 in the following location/folder “C:\Users\user\Desktop\Excel”.

Each workbook has One worksheet and I want to have a Master workbook containing all the worksheets from the 1.00 to 1.13 workbooks.

To be specific, the Master workbook will contain the 14 worksheets and Each worksheet must be named Sheet0 to Sheet13. With Sheet0 corresponding to workbook 1.00, Sheet1 to workbook 1.01, etc

How can I accomplish this with VBA or there are easier ways to do this?

Thanks

Jonah
 
Top