This documentation is archived and is not being maintained.

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: