3305 Main Street Ste 019 Vancouver, WA 98663

OCIWorkbook Function

The OCIWorkbook function returns the name of the workbook. The three optional parameters determine which parts of the name are returned.

Syntax

OCIWorkbook( [ path ] , [ name ] , [ extension ] )

The OCIWorkbook function syntax has these parts:

Value 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 OCIWorkbook(True, False, True) would return C:\Templates\*.xlt - the search path for all templates in that directory.