Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Application.LibraryPath Property (Excel)

Returns the path to the Library folder, but without the final separator. Read-only String.

expression .LibraryPath

expression A variable that represents an Application object.

This example opens the file Oscar.xla in the Library folder.

pathSep = Application.PathSeparator 
f = Application.LibraryPath & pathSep & "Oscar.Xla" 
Workbooks.Open filename:=f
Show:
© 2015 Microsoft