Excel Sheet Move r Command Line

Need a more powerful tool than XLS Sheet Mover?  Click  here for 'Convert XLS'. 

Using XLS Sheet Mover - Command Line

 

XLSM can be ran without a user interface with command line  arguments much like in the good old DOS days.  Alternatively you can create a command line execution by going to the Windows START-RUN menu and typing it in there.  The syntax for the command line is:

 

XLSM /S{Source File(s)} [/Y#]  /T{Target File(s)} [/Z#]  [/A] [/F] [/V] [/N] [/X] [/M#] [/B]

 

Items above enclosed in square brackets “[ ]” are optional, all other ‘switches’ are required.  Therefore /S,  /T, should always be specified on the command line. 

You can include or exclude spaces between switches and parameters.  For example,  "/Z6" is the same as "/Z  6".  For long file names you may be required to use double quotes.  For example /S"C:\Program Files\MyApp\MyExcelDoc.XLS".

 

Full descriptions for each switch is shown below:

 

Switch

Meaning

/S{File}

Source File(s) to be copied from

 

A single file including it's complete path must be specified (i.e. "D:\MyExcelFiles\MyExcelFile.XLS". 

/Y#

Source file sheet number to copy.    Defaults to 1 if omitted.

/T{File}

Target File(s) to be saved after conversion.  These files are created from the Source file(s) and the conversion method selected. 

 

If converting a single file, make sure that the /T switch also specifies a single output file (i.e. "D:\MyExcelFiles\TargetOutput.CSV". 

 

If specifying a whole directory, make sure the /T also specifies a whole directory with a new target file extension (i.e. "D:\MyExcelFiles\*.CSV").

/Z#

Target file sheet number to copy.    Defaults to 1 if omitted.

/A

Add Worksheets to the target Workbook if not enough exist.  May be required in those cases where the target sheet number simply doesn't exist.

/F

 Copy Formulas of the Worksheet.  If neither /F or /U is specified, values are copied by default.

/V

Verbose.  To see all possible dialogs and a status message after completion, specify this switch.  To run silently, use the /V switch.

/N

Copy the name of the Source sheet.  Must be careful that the target Workbook does not already contain a similarly named sheet.

/X

Exit after completion

 

/M#

Timeout value in seconds.  This timeout value is the longest time XLSM will wait for the source or target file to exist.  Therefore the timeout helps in those circumstances where the creation of the source or target file may be pending for quite some time.

/B

Beep when done