Forum

Notifications
Clear all

VBA to Merge Files

2 Posts
2 Users
0 Reactions
62 Views
(@shoaibali)
Posts: 8
Active Member
Topic starter
 

I have 10 files and each files contains Sheet1 how can i put these 10 files into one file as 10 sheets.

Please share VBA Code

 
Posted : 20/02/2020 1:58 pm
(@purfleet)
Posts: 412
Reputable Member
 

try the attached

The full file path goes in B1 and then Yes or No if you want to copy headers over or not

Purfleet

 
Posted : 22/02/2020 6:22 pm
Share: