troubleshooting Question

Append multiple Excel workbooks with multiple sheets into a new workbook

Avatar of Tracy Sherman
Tracy Sherman asked on
Microsoft ExcelVB ScriptMicrosoft Office
44 Comments1 Solution281 ViewsLast Modified:
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.

Berkson Wein
Tech Freelancer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 44 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 44 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros