Hi all,
I've been trying to share a workbook with a third party in which I use several UDFs that are defined in an add-in (I call it 'TableMatch.xlam'). I ask the third party (currently the third party is being represented by my old laptop, for testing purposes) to paste TableMatch.xlam into the appropriate add-ins directory, and make sure it is activated (tick in the tick box) in the list of add-ins under Options > Add-ins > Manage [Excel add-ins]{Go}. I hoped that Excel would then interpret formulae referencing the relevant UDFs (say MyFunction(a,b,c) for example) as references to the function MyFunction in the add-in. Instead, however, the formulae get expanded out to e.g. 'C:\Users\...\Addins\TableMatch.xlam'!MyFunction(a,b,c). That path does not exist on the third party computer and so the formula returns an error. I should note that the functions in TableMatch.xlam are referenced both in formulae in the workbook and via VBA functions included in a module in the workbook itself - to facilitate this, I've included a "Reference to TableMatch.xlam' in the main workbook (see attached image to calrify what I mean). That's not something I've done before and I really don't understand the wider implications of including that reference (and in particular whether it is making it more complicated to keep the references to MyFunction() working).
I've struggled to find a good article online that explains how Excel handles this type of situation, and how I could resolve it, so I was hoping someone could point me in the right direction. I apologise in advance to the gods of Excel if this is essentially a result of not doing things properly, I'm very much self-taught and just trying to hack things together - grateful for any advice or pointers to articles on how to make this (or any) type of system of UDFs robust to sharing to other users's computers . I appreciate that the simplest answer would be not to use complicated systems of UDFs in workbooks I want to share with third parties, but (in my head...) I do have reasons for doing it this way!
Yours,
Chris
Bookmarks