Application.LibraryPath returning invalid path

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

We are copying our XLA to the Excel Application.LibraryPath directory during
the install. We we are on French Windows (XP Pro) and French Office (2003)
this property is returning "c:\program files\microsoft
office\office11\macrolib". This path does not exist.

Known bug? I cannot find anything on the web for it.
 
Hi Mike

Post this in a French Newsgroup to see if it return the wrong path on other
machines also.
 
Hi,

This directory is OK (except Office10) with a French Excel 2002 and
Windows 98

I got same thing with this:

Sub librarypath()
Dim dirpath As String
dirpath = Application.librarypath
MsgBox dirpath
End Sub

But I cannot test with Windows XP Pro and Office 2003
 
Hi,

According to following example, in French Excel VBA Help, you must
add path separator yoursel between "LibraryPath" and final file.

beginning copy:

Exemple
Cet exemple montre comment ouvrir le fichier « Oscar.xla » dans le
dossier Macrolib.

pathSep = Application.PathSeparator
f = Application.LibraryPath & pathSep & "Oscar.Xla"
Workbooks.Open filename:=f

End of copy
 
Back
Top