RUN ADD-IN AS PART OF MACRO

[DeanP]

I want to run an add-in as part of my macro. The .xlam file is installed and can be run independently but I would like to do it through VBA. Can anyone help me to do this?

[Paul_Hossler]

Google is Good


https://stackoverflow.com/questions/29141672/application-run-of-addins-macro

https://www.rondebruin.nl/win/s9/win001.htm

[DeanP]

Thanks.

That has not helped. I still can't get it to work.

[Paul_Hossler]

This is marked SOLVED

Some more details and an example will help


Seems to work for me - are you doing something different?



Three Files

1. Hello_Source.xlsm - non-addin version of the test file


2. Hello_Addin.xlam.zip - addin version of the test file, save in Add In folder and remove the fake .zip part which I had to add to be able to post the xlam file


Install the add in using Options, AddIns

23502

Finally

3. CallAddin.xlsm is simple driver file with the Application.Run …. tied to a button

23498

Let me know if these don't work, but as the above screen shot shows it can be made to work