The OCIWorkbook function returns the name of the workbook. The three optional parameters determine which parts of the name are returned.
OCIWorkbook( [ path ] , [ name ] , [ extension ] )
The OCIWorkbook function syntax has these parts:
|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.|
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.