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.