EXAMPLE 3 Add a new sheet to many workbooks, specify it as the 1st sheet

To add a new sheet by the name of "FirstSheet" to all the workbooks in "D:\XLSFiles\" the following syntax would be used:

ConvertXLS.EXE /S"D:\XLSFiles\*.XLS" /T"D:\XLSFiles\*.XLS" /P104 /1"FirstSheet" /2firstfirst /4TRUE

Note: You don't have to specify Boolean (TRUE/FALSE) parameters that are FALSE. Nor do you have to specify parameters that are empty.

The /S and /T switches specify input and output workbook respectively, which in this case is the same workbook. You can optionally keep the input file unchanged by specifying a different name or path for the output file.

In this example, notice that even if "LastSheet" already exists, it will be completely overwritten by a new empty sheet, and placed as the first sheet in the workbook.