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

  • Thread starter Thread starter Charles Jordan
  • Start date Start date
C

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
 
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
 
Peter T said:
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
Click to expand...

Ptere - XL2k is our earliest supported - .UserLibraryPath looks the
best. Tks vm - Charles
 
Ptere - XL2k is our earliest supported - .UserLibraryPath looks the
Peter - sorry about mis-spelling your name. Charles
Click to expand...

No problem, I often mistype it my self.

Regards,
Petre T
 
Back
Top