asked on

Excel Addins

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.

Glenn

glennwaldron

ASKER

I have copied all the sheets from the current workbook to a new workbook and they now recognise the addin.

I would still like to know why if there is a reason so I'll leave the question open.

ASKER CERTIFIED SOLUTION

cri

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

turn123

glennwaldron,
No comment has been added lately (306 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: split points between cri http:#8047310 and byundt http:#8133866

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

turn123
EE Cleanup Volunteer