-This function was introduced in version 2.00.0018.
function returns the name of the workbook. The three optional parameters determine which parts of the name are returned.
] , [name
] , [extension
function syntax has these parts:
||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.
||Optional. Pass False to omit the workbook name.
||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
, then *.
will be returned for the name component. For example, if you had a workbook C:TemplatesExample.xlt, then calling OCWorkbook
(True, False, True) would return C:Templates*.xlt - the search path for all templates in that directory.