Save the workbook to a PDF.
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. |
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 output PDF. |
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
|
Compliance (7.3) |
Indicates whether to produce a PDF/A-1b compliant PDF. The default is PDF/A-1b.
Specify one of the following values or an arbitrary value:
<blank> None PDF/A-1b
|
Optimization (7.3) |
Indicates whether to produce a standard or size-optimized PDF. The default is Standard.
Specify one of the following values or an arbitrary value:
<blank> Standard MinimumSize
|
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
|
BackgroundExecute | Controls whether the method is executed asynchronous. |
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. |
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 output PDF. |
Folder | Specify the folder to save the PDF to. |
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
|
Compliance (7.3) |
Indicates whether to produce a PDF/A-1b compliant PDF. The default is PDF/A-1b.
Specify one of the following values or an arbitrary value:
<blank> None PDF/A-1b
|
Optimization (7.3) |
Indicates whether to produce a standard or size-optimized PDF. The default is Standard.
Specify one of the following values or an arbitrary value:
<blank> Standard MinimumSize
|
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
|
BackgroundExecute | Controls whether the method is executed asynchronous. |
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. |
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 output PDF. |
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
|
Compliance (7.3) |
Indicates whether to produce a PDF/A-1b compliant PDF. The default is PDF/A-1b.
Specify one of the following values or an arbitrary value:
<blank> None PDF/A-1b
|
Optimization (7.3) |
Indicates whether to produce a standard or size-optimized PDF. The default is Standard.
Specify one of the following values or an arbitrary value:
<blank> Standard MinimumSize
|
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
|
BackgroundExecute | Controls whether the method is executed asynchronous. |
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. |