Application.LibraryPath property (Excel)
Returns the path to the Library folder, but without the final separator. Read-only String.
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
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.