Combine xlsm file with a xlsx file

[jaime1182]

Hope everyone is safe and well during these times. I have been given a project to manage the workshifts.

I have been given the individual workbooks (xlsx).
I need to merge this workbook with a worksafe generic guide (xlsx) and another (which contains a macro) and rename the full merge file with another name on a list but with as xlsm extension.

I saw this (VBA Code to Combine Multiple Workbooks into one Worksheet) but this combines everything in the folder which isn't - not one with everything else. I'm not proficient enough to try and modify that either.

 

[Dan_W]

Sorry - just to clarify - how many workbook are you looking to merge into one? Your title suggests that it's just one of each (1 x xlsx and 1 x xlsm). Unless I'm missing something obvious, wouldn't it just be a matter of copying the XLSX worksheets across to the XLSM file with the macro, no? Sorry - I just want to make sure I'm clear on what it is you to want to do.