XLA or Reference or Nothing at all
 

Hi guys,

I have made a program in Excel VBA and distribute it to my clients.

I have had a hell of problems in the past, so see my short history.

From 2000 to 2003, I had a .xls file with VBA-code and made a reference to
it from my activeworkbook that used the code
From 2003 till now, I converted it to a .xla addin and placed it in the
Addins list from excel, so my activeworkbook could use it.

The problems I encountered were always with the userprofile: if I renamed or
replaced my vba-code, it took many effort to programmatically change it in
the userprofile of windows (or I had to delete te userprofile, so the code
could reinstall everything correct).

I am now discovering that it is not necessary to make a reference or put the
application in the addin-list, because my code still works if it is not in
the list. Moreover, it is loaded, only by starting up excel, which is not
necessary everytime.

Can anyone tell me what the specific advantage is to put the addin in the
list of addins, since the code works by only loading it from starting up a
workbook that loads the specific xla-file code?

Thanks
Jos Vens