Embedding add-in into Excel worksheet

[Philrock]

I use a number of Excel add-ins (.xla) including some I have downloaded and some I have written. I don’t have access to the code for the ones I downloaded.

I have had difficulty sharing Excel worksheet files (.xls) with clients when the worksheet files use the add-ins. My understanding is that if the .xla file is put in the /.../xlstart/ directory, the add-in should load every time Excel starts, and worksheets using the add-in should work. Seems to work this way on my computer, but my clients have not been able to get them to work. Am I doing something wrong? Is there a way to embed the add-in into the worksheet, so the user (and I) do not have to bother with the separate .xla file?

 

[cummings54]

One possible solution is to establish a reference to the addin in the workbook you will distribute. This is done by using the Tools:References menu item from within the Visual Basic Editor. In the References Dialogue click the browse button and navigate to the directory containing the Addin and then select it.

In the project window you will now see a new branch on the project tree called "References" with a leaf called "References to XXX" where XXX is you addin name. This technique is called early binding. It should only be used if you are sure the addin will be located in the directory you poined to.

Now user defined functions inthe addin can be called just as if the addin were