Copy a specified worksheet in the workbook.
Overload Name | Description |
---|---|
FromFile (7.7) | Copy a specified worksheet from an Excel file into the current view. |
General | Copy a worksheet. |
Copy a specified worksheet from an Excel file into the current view.
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 to copy from. |
Folder | Specify the full path to the folder that contains the file. |
ValuesOnly |
Whether to replace cell formulas with cell values. If left blank FALSE will be used.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SheetName | Specify the name of the sheet to copy. |
NewSheetName | The name of the new sheet. |
ToPositionPolicy |
Select how to specify where to copy the worksheet to. If left blank "Last" will be used.
Specify one of the following values or an arbitrary value:
<blank> First Last ToPositionOfSheetNamed ToPositionNumber
|
ToPosition | If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number. |
Password | The password assigned to the saved workbook. |
Copy a worksheet.
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
|
FromWorkbook | The name of the workbook to copy the sheet from. Leave blank to copy from current workbook. |
SpecifyFromBy |
Select how to specify which worksheet to copy. If left blank SheetNumber will be used.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber
|
FromSheetSpec | Specify the sheet-name or sheet-number, depending on SpecifyFromBy. |
SpecifyToPosition |
Select how to specify where to copy the worksheet to. If left blank "Last" will be used.
Specify one of the following values or an arbitrary value:
<blank> First Last ToPositionOfSheetNamed ToPositionNumber
|
ToPosition | If ToPositionPolicy is ToPositionOfSheetNamed then enter a sheet name. If ToPositionPolicy is ToPositionNumber then enter a number. |
NewSheetName | The name of the new sheet. |