Which is the best installation target folder for Add-ins ?

[Charles Jordan]

Hi all. We have multiple student users with all versions of Excel and
great confusions about the most trouble-free location for add-ins,
(and the dates of add-in versions)

Which is better :

?Application.LibraryPath
C:\Program Files\Microsoft Office\OFFICE11\LIBRARY, or:

?Application.UserLibraryPath
C:\Documents and Settings\Charles\Application Data\Microsoft\AddIns\

Thanks - Charles

 

[Peter T]

Hi Charles,

An Addin can of course go in any folder but possibly the most trouble free
would be the folder that opens by default when you "browse" to Addins. I
think that's normally .UserLibraryPath for XL2k and later

If there's a possibility any of your users have XL97 then:

Sub test()
If Val(Application.Version) >= 9 Then
Debug.Print Application.UserLibraryPath 'not xl97
End If
Debug.Print Application.LibraryPath
End Sub

Regards,
Peter T

 

[Charles Jordan]

Hi Charles,

An Addin can of course go in any folder but possibly the most trouble free
would be the folder that opens by default when you "browse" to Addins. I
think that's normally .UserLibraryPath for XL2k and later

If there's a possibility any of your users have XL97 then:

Sub test()
If Val(Application.Version) >= 9 Then
Debug.Print Application.UserLibraryPath 'not xl97
End If
Debug.Print Application.LibraryPath
End Sub

Regards,
Peter T

Ptere - XL2k is our earliest supported - .UserLibraryPath looks the
best. Tks vm - Charles

 

[Charles Jordan]

Ptere - XL2k is our earliest supported - .UserLibraryPath looks the
best. Tks vm - Charles

Peter - sorry about mis-spelling your name. Charles

 

[Peter T]

Ptere - XL2k is our earliest supported - .UserLibraryPath looks the

Peter - sorry about mis-spelling your name. Charles

No problem, I often mistype it my self.

Regards,
Petre T