ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   run excell macro on add-in menu (https://www.excelbanter.com/excel-programming/316457-run-excell-macro-add-menu.html)

benjy[_2_]

run excell macro on add-in menu
 

I am trying to run a add-in macro, with a macro.... (Sorry, i`m
newbie)
I need to call the add-in, select a "basic" option, and click OK
couple of times for the macro to start. Only problem is I need to d
this a few hundered times

--
benj
-----------------------------------------------------------------------
benjy's Profile: http://www.excelforum.com/member.php...fo&userid=1634
View this thread: http://www.excelforum.com/showthread.php?threadid=27733


Tom Ogilvy

run excell macro on add-in menu
 
One more time:

application.Run "MyAddin.xla!Macro1"

would be the basic approach.

--
Regards,
Tom Ogilvy

"benjy" wrote in message
...

I am trying to run a add-in macro, with a macro.... (Sorry, i`m a
newbie)
I need to call the add-in, select a "basic" option, and click OK a
couple of times for the macro to start. Only problem is I need to do
this a few hundered times.


--
benjy
------------------------------------------------------------------------
benjy's Profile:

http://www.excelforum.com/member.php...o&userid=16344
View this thread: http://www.excelforum.com/showthread...hreadid=277331





All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com