Application.LibraryPath returning invalid path
 

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.

Application.LibraryPath returning invalid path
 

Hi Mike

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mike" wrote in message ...
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.

Application.LibraryPath returning invalid path
 

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


"Mike" a écrit dans le message de
...
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.

Application.LibraryPath returning invalid path
 

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

"Mike" a écrit dans le message de
...
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.