f$Excel create sheet
f$Excel create sheet
Create a new sheet in the current Excel workbook. If the sheet already exists, the status –2 is returned. The error message from Excel can be obtained with: f$Excel(’Error’, ParameterName ).
Syntax: | Status = f$Excel('Sheet', 'create', Name ) | ||
| Argument | Type | Meaning |
| 'Sheet' | String | Keyword |
| 'create' | String | Keyword |
| Name | String | Name of the sheet to be created. |
Result: | Integer | 0: command executed successfully | |
Example: | Status = f$Excel('Workbook','create','c:\\temp\\test2.xls') | ||