Description: Changes the number format of selected cells.
Parameters:
ChangeNumberFormat(sPathOriginal As String, PathTarget As String, sSheet As String, sRangeToChange As String, sNewFormat As String)
|
Parameter |
Meaning |
|
sPathOriginal |
Excel file from which to change the number format |
|
sPathTarget |
Can be same as sPathOriginal, otherwise a new workbook is created. |
|
sSheet |
Sheet to change number formatting |
|
sRangeToChange |
Range of cells that will have new formatting applied to |
|
sNewFormat |
The new number format that will be applied to sRangeToChange |
Return Values:
0: Success
-3: Unable to create Excel Application. Is it installed?
-4: Unable to destroy Excel Application.
-200: Excel reported an error.
-201: Shareware Expired.
-208: Target path folder does not exist, even after attempting to create it.
-213: Invalid or missing sheet specified.