Embedding add-in into Excel worksheet
Embedding add-in into Excel worksheet
(OP)
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?
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?





RE: Embedding add-in into Excel worksheet
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