3305 Main Street Ste 019 Vancouver, WA 98663

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:

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.