Start up folder v Addin folder

[Kieran]

Hi - quick question

Background

I have created an .xla that I expected to be distributed to the add-ins
folder of each potential user (msi package that will copy the file to
the appropriate location)

However, Local IT support in one of our sites would prefer it copied
to the Excel startup folder.

I prefer the 'add-in folder approach' as it allows users to easily
choose whether the add-in is loaded or not.

Local IT support understandably prefer the 'Start-Up folde'r approach
as they feel they will get less support calls.

Question

Are there any good reasons why the Start-Up folder is not a good load
method for XLA's

Many thanks

Kieran

 

[Dave Peterson]

How about a third option?
A common folder on a network drive that can be accessed by all. Then
Tools|Addins and install from there. (I'd use the UNC path name--not the mapped
drive path.)

Or a fourth option.
A dedicated folder on the end user's pc--but a name that is common to all:

C:\myAddinsFromKieran
(or some unique name)

If you have any UDFs that in formulas in workbooks that are shared between uses
(with the addin), then you may be able to avoid #name? errors where the UDF
can't be found--since it's not in the same drive/folder location as the person
who sent the workbook.