VBA code to merge data from different workbook into one Master File

[Mandy_84]

Hi!
Looking for a VBA code that copies a specific range in a certain tab from different passwordprotected files into one sheet of the Masterfile one after another.

- all workbooks in one folder
- one password for all workbooks
- the range is H36:K48 and to be pasted to sheet1 of the Masterfile range A:D
- the tab "Employee"

Thanks a lot!

 

[Roger Govier]

Hi

If you have Office 365 or Excel 2013 or later you don't need VBA.
You can use Power Query to carry out the task.
Plenty of examples available including Power-query-consolidate-excel-sheets

 

[Mandy_84]

Hi

If you have Office 365 or Excel 2013 or later you don't need VBA.
You can use Power Query to carry out the task.
Plenty of examples available including Power-query-consolidate-excel-sheets

Also for passwordprotected workbooks (around 50 files)?

 

[Roger Govier]

Hi
No, I had missed the point about the files being password protected.
Why not just set file system permission on the location where the file sits?
Passwords on spreadsheets can easily be compromised with free tools on the internet.

If you did this then Power Query would work fine with any number of files and on refreshing would also add the data from any additional files added to the folder.