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