Application.LibraryPath property (Excel)
Returns the path to the Library folder, but without the final separator. Read-only String.
Syntax
expression.LibraryPath
expression A variable that represents an Application object.
Example
This example opens the file Oscar.xla in the Library folder.
pathSep = Application.PathSeparator
f = Application.LibraryPath & pathSep & "Oscar.xla"
Workbooks.Open filename:=f
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.