OCWorkbook Function

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:

ArgumentDescription
pathOptional. 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.
nameOptional. Pass False to omit the workbook name.
extensionOptional. 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.