Avatar of Tracy Sherman
Tracy Sherman

asked on 

Append multiple Excel workbooks with multiple sheets into a new workbook

Dear Experts,

How do I append multiple Excel workbooks (Excel 2013) with multiple sheets into a new workbook using visual basic?

I have 14 workbooks with identical number of worksheets in each.
I need to append the workbooks in a specific order.
First one is ADSL.xlsx, second is ADAE.xlsx, and then the rest are in aphabetical order (ADCM, ADEFF, ADEX, etx.).
All workbooks are in the same folder.

I have attached the first 3 workbooks.

Microsoft ExcelVB ScriptMicrosoft Office

Avatar of undefined
Last Comment
Berkson Wein

8/22/2022 - Mon