EXAMPLE 2 Copy specified range of formula from one workbook to another

To copy a specific range (B5:K10) of Formulas of "Sheet2" of the workbook "D:\XLSFiles\A.XLS", to "Sheet3" (placing the contents beginning at cell J10) of the workbook "D:\XLSFiles\B.XLS", the following syntax would be used:

 

ConvertXLS.EXE /S"D:\XLSFiles\A.XLS" /T"D:\XLSFiles\B.XLS" /P101 /1"Sheet2" /2 1 /4TRUE /5B5:K10 /6"Sheet3" /7TRUE /8J10

Note it is highly encouraged that you use the Verbose (/V) switch initially to see what the status of your conversion is.

Examples:

EXAMPLE 1: Copy all values from one sheet to another, within same workbook

EXAMPLE 2: Copy specified range of formula from one workbook to another

EXAMPLE 3: Append sheet data from a folder of workbooks to a single sheet

EXAMPLE 4: Example 4 Copy ALL including column widths from one workbook to another

P101 Copy Specified Sheet Data to same or different XLS file