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

Title: Combine multiple excel files to a single workbook of multiple tabs/worksheets
Post by: jheyman on October 30, 2015, 11:00:18 AM

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.

Title: Re: Combine multiple excel files to a single workbook of multiple tabs/worksheets
Post by: td on October 30, 2015, 11:22:56 AM

You might start by reading the following recent forum thread:

http://forum.winbatch.com/index.php?topic=1482.msg7101#msg7101 (http://forum.winbatch.com/index.php?topic=1482.msg7101#msg7101)

Title: Re: Combine multiple excel files to a single workbook of multiple tabs/worksheets
Post by: td on October 30, 2015, 01:10:01 PM

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.

WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: jheyman on October 30, 2015, 11:00:18 AM