LRWorkbook Function

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

This function can be added to your worksheet by using the Function Wizard.

Syntax

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

The LRWorkbook function syntax has these parts:

ValueDescription
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:TemplatesExample.xlt, then calling LRWorkbook(True, False, True) would return C:Templates*.xlt - the search path for all templates in that directory.