Combine multiple excel files to a single workbook of multiple tabs/worksheets

Started by jheyman, October 30, 2015, 11:00:18 AM

Previous topic - Next topic

jheyman

I am trying to take multiple excel files (each file has one worksheet) and merge them into one excel file with each file turned into a separate worksheet/tab in the new combined excel file.

Can someone offer some help on how I would do that with winbatch?

thanks.

td

"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

td

You may also want to checkout the Excel related articles in the Tech Database (link in the menu near the top of this page.)  Use the search term 'Excel' to find many articles including a few on saving and loading files into sheets and workbooks. 
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade