Save the workbook to an Excel file.
Overload Name | Description |
---|---|
Desktop | Save to the desktop of the current user. Specify the file name. |
General | Specify the full path. |
MyDocuments | Save to the My Documents folder of the current user. Specify the file name. |
Specify (7.6) | Save workbook specifying the file name, file type, and folder. |
Save to the desktop of the current user. Specify the file name.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Filename | Specify the name of the file. |
IncrementFilename |
Whether to add a subscript to the filename if the specified file already exists. If not true, an existing file with the same name will be overwritten.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UseDialog |
Whether to show the Save File dialog to allow the user to select the folder and filename.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DialogResultPropertyName (7.7) | The name of the script property to hold the FileDialog form result. |
FullFilePathPropertyName (7.7) | The full path of the files that is saved. |
Password | The password assigned to the saved workbook. |
Specify the full path.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Filename | Specify the name of the file. |
Folder |
Specify the folder to save the file to. Defaults to MyDocuments if not specified.
Specify one of the following values or an arbitrary value:
<blank> DeskTop MyDocuments
|
IncrementFilename |
Whether to add a subscript to the filename if the specified file already exists. If not true, an existing file with the same name will be overwritten.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UseDialog |
Whether to show the Save File dialog to allow the user to select the folder and filename.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DialogResultPropertyName (7.7) | The name of the script property to hold the FileDialog form result. |
FullFilePathPropertyName (7.7) | The full path of the files that is saved. |
Password | The password assigned to the saved workbook. |
Save to the My Documents folder of the current user. Specify the file name.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Filename | Specify the name of the file. |
IncrementFilename |
Whether to add a subscript to the filename if the specified file already exists. If not true, an existing file with the same name will be overwritten.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UseDialog |
Whether to show the Save File dialog to allow the user to select the folder and filename.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DialogResultPropertyName (7.7) | The name of the script property to hold the FileDialog form result. |
FullFilePathPropertyName (7.7) | The full path of the files that is saved. |
Password | The password assigned to the saved workbook. |
Save workbook specifying the file name, file type, and folder.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Filename | Specify the name of the file. |
FileType |
Specify to the file type of saved workbook. Defaults to OpenXMLWorkbook if not specified. CSV: Specifies a text file of comma-separated values. Typically saved with the .csv filename extension. Excel8: Specifies the Biff 8 File format which is the default file format of Excel 97, Excel 2000, Excel 2002 (XP) and Excel 2003. This format is also supported by Excel 2007-2016. Typically saved with the .xls filename extension. OpenXMLWorkbook: Specifies the Excel 2007-2016 Open XML file format. Typically saved with the .xlsx filename extension. OpenXMLWorkbookMacroEnabled: Specifies the Excel 2007-2016 macro enabled Open XML file format. Typically saved with the .xlsm filename extension. UnicodeText: Specifies a tab-delimited Unicode text file encoded as UTF-8. Typically saved with the .txt filename extension.
Specify one of the following values or an arbitrary value:
<blank> CSV Excel8 OpenXMLWorkbook OpenXMLWorkbookMacroEnabled UnicodeText
|
Folder |
Specify the folder to save the file to. Defaults to MyDocuments if not specified.
Specify one of the following values or an arbitrary value:
<blank> DeskTop MyDocuments
|
IncrementFilename |
Whether to add a subscript to the filename if the specified file already exists. If not true, an existing file with the same name will be overwritten.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UseDialog |
Whether to show the Save File dialog to allow the user to select the folder and filename.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DialogResultPropertyName (7.7) | The name of the script property to hold the FileDialog form result. |
FullFilePathPropertyName (7.7) | The full path of the files that is saved. |
Password | The password assigned to the saved workbook. |