Merge 2 Workbooks with Macros

I’m trying to merge 2 workbooks with macros and data.
Lets say I have ExcelA and ExcelB and I try to combine them
ExcelA.Combine(ExcelB);
But when I see the output ExcelA keeps their macros and does not contains ExcelB’s Macros.

Is there any work around to do it?.

Thanks

@f.menseguez,
It is expected behaviour as we can combine workbooks with various content like images, charts and data into a single workbook. Macros are not combined during the Combine operation.

However, you may please give a try to the sample code in the following article which copies VBA macros from one file to the other one and share your feedback with us.