View Full Version : [SOLVED:] RUN ADD-IN AS PART OF MACRO
DeanP
01-02-2019, 06:08 PM
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
01-02-2019, 06:42 PM
Google is Good
https://stackoverflow.com/questions/29141672/application-run-of-addins-macro
https://www.rondebruin.nl/win/s9/win001.htm
DeanP
01-02-2019, 07:30 PM
Thanks.
That has not helped. I still can't get it to work.
Paul_Hossler
01-02-2019, 08:47 PM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.