| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which is the best installation target folder for Add-ins ?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which is the best installation target folder for Add-ins ?
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" wrote in message om... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which is the best installation target folder for Add-ins ?
"Peter T" <peter_t@discussions wrote in message ...
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" wrote in message om... 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 Ptere - XL2k is our earliest supported - .UserLibraryPath looks the best. Tks vm - Charles |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which is the best installation target folder for Add-ins ?
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Which is the best installation target folder for Add-ins ?
Ptere - XL2k is our earliest supported - .UserLibraryPath looks the
best. Tks vm - Charles Peter - sorry about mis-spelling your name. Charles No problem, I often mistype it my self. Regards, Petre T |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Christmas Lights Installation Los Angeles, Beverly Hills, SantaMonica, Culver City, Marina Del Rey, Calabasas, Agoura Hills Thousand OaksHoliday Lights Installation 1-310-925-1720 | Excel Worksheet Functions | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| How find if target is object in Worksheet_Change (ByVal Target As.. ?) | Excel Programming | |||
Hybrid Mode
