Application.LibraryPath returning invalid path

[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.

 

[Ron de Bruin]

Hi Mike

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

 

[Clément Marcotte]

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

 

[Clément Marcotte]

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