Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |