LibraryPath Property
Applies To
Application object.
Description
Returns the path to the Library folder, but without the final separator. Read-only String.
Example
This example opens the file Oscar.xla in the Library folder (the Macro Library folder on the Macintosh).
pathSep = Application.PathSeparator
f = Application.LibraryPath & pathSep & "Oscar.Xla"
Workbooks.Open filename:=f