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?
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
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thanks.
That has not helped. I still can't get it to work.
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
Capture2.JPG
Finally
3. CallAddin.xlsm is simple driver file with the Application.Run …. tied to a button
Capture.JPG
Let me know if these don't work, but as the above screen shot shows it can be made to work
Last edited by Paul_Hossler; 01-02-2019 at 09:09 PM.
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3