Combine Multiple Table Into Sheets In One Excel

Question

Hi, I want to ask how can we combine 9 different tables with different structures into sheets in one single Excel file. Plus, how to put DateTimeNow in the Excel file name after the run?

SyamaliaFaiqah01 · Answer

Thank you!

binu_acs · Answer

@SyamaliaFaiqah01 This can be done using batch macro

Write_Multiple_Sheets_220124.yxzp

SyamaliaFaiqah01 · Answer

These are the sample inputs and the result I want.

code 1.xlsx

code 2.xlsx

result.xlsx