Question:
How do I take multiple XLS or XLSX output files and merge them into one (and have multiple tabs)?
Answer:
Follow these steps.
1) Create a batch that does either XLS or XLSX, all exporting to File (any directory), with unique output names.
2) Save the batch
3) Click the INI button to bring up the batch-specific INI settings
4) Right-Click to bring up settings menu
5) Go to the [XLS/XLSX] group and insert it
6) Insert the "XLSMerge=YES" option
7) Set other settings desired from that menu
8) Run batch and file will be merged
---
Note: You can name the tabs in the Job window. There is a field for this displayed when exporting to XLS/XLSX.
