NOTE - This function was introduced in version 2.00.0018.
The OCWorkbook function returns the name of the workbook. The three optional parameters determine which parts of the name are returned.
Syntax
OCWorkbook( [ path ] , [ name ] , [ extension ] )
The OCWorkbook function syntax has these parts:
| Argument | Description |
|---|---|
| path | Optional. Pass False to omit the path to the workbook. Note that the path does not exist for a new workbook until it has been saved. |
| name | Optional. Pass False to omit the workbook name. |
| extension | Optional. Pass False to omit the file extension. Note that the file extension does not exist for a new workbook until it has been saved. |
Remarks
If you pass False for name and a non-blank value is returned for path and extension, then *. will be returned for the name component. For example, if you had a workbook C:\Templates\Example.xlt, then calling OCWorkbook(True, False, True) would return C:\Templates\*.xlt - the search path for all templates in that directory.
Example
Click here for examples.