EXAMPLE 2 Copy entire worksheet from one workbook to a new workbook

To copy the "Sheet1" of the workbook "D:\XLSFiles\B.XLS", to a target sheet named "CopyOfSheet1" and placed it in a new workbook "D:\XLSFiles\C.XLS" in front of a sheet named "Summary", the following syntax would be used:

ConvertXLS.EXE /S"D:\XLSFiles\B.XLS" /T"D:\XLSFiles\C.XLS" /P102 /1"Sheet1" /2Summary /40 /5"CopyOfSheet1"

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 are different . You can optionally keep the input file unchanged by specifying a different name or path for the output file.