LibraryPath Property [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
Application.LibraryPath Property
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.

Visual Basic for Applications
pathSep = Application.PathSeparator
f = Application.LibraryPath & pathSep & "Oscar.Xla"
Workbooks.Open filename:=f

See Also