OVH Cloud OVH Cloud

Application.LibraryPath returning invalid path

3 réponses
Avatar
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.

3 réponses

Avatar
Ron de Bruin
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 news:%
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 filesmicrosoft officeoffice11macrolib". This path does not
exist.

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





Avatar
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


"Mike" a écrit dans le message de
news:%
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 filesmicrosoft
officeoffice11macrolib". This path does not exist.

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





Avatar
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

"Mike" a écrit dans le message de
news:%
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 filesmicrosoft
officeoffice11macrolib". This path does not exist.

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