Posted on 2003-02-26
I have written some functions that retrieve data from an Access Database. These work OK.
Because I need to use these same functions in other Excel workbooks I created an XLA addin and opened XLA addin in my file. Everything still works OK, even though there are 2 functions with same name.
I then deleted the code from my workbook leaving only the code in the XLA for the workbook to use. Now it doesn't work. The workbook doesn't recognise the XLA.
I then created a new empty workbook and opening the addin the functions work OK.
Why would the addin work OK in one file and not in the other?
I can get around this by having duplicate code in many workbooks but that is too difficult to maintain.
Any help appreciated.