Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble calling Add-In Macros
I created an Excel Add-in with some macros in a module. I went to
Tools Add-Ins and selected the Add-In so it loads everytime I open Excel. When I try to call one of the Add-In macros from a macro in my main excel file, it doesn't work. My main excel macros can't see the Add-In's macros. How do I get them to see the Add-In's macros. --Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble calling Add-In Macros
Hi Scott,
Try: Public Sub Tester() Application.Run ("MyAddin.xla!MyMacro") End Sub Replace the addin and macro names to accord with your values. --- Regards, Norman wrote in message oups.com... I created an Excel Add-in with some macros in a module. I went to Tools Add-Ins and selected the Add-In so it loads everytime I open Excel. When I try to call one of the Add-In macros from a macro in my main excel file, it doesn't work. My main excel macros can't see the Add-In's macros. How do I get them to see the Add-In's macros. --Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble calling Add-In Macros
If the add-in name has embedded spaces use
Application.Run "'My Addin.xla'!MyMacro" -- HTH RP (remove nothere from the email address if mailing direct) "Norman Jones" wrote in message ... Hi Scott, Try: Public Sub Tester() Application.Run ("MyAddin.xla!MyMacro") End Sub Replace the addin and macro names to accord with your values. --- Regards, Norman wrote in message oups.com... I created an Excel Add-in with some macros in a module. I went to Tools Add-Ins and selected the Add-In so it loads everytime I open Excel. When I try to call one of the Add-In macros from a macro in my main excel file, it doesn't work. My main excel macros can't see the Add-In's macros. How do I get them to see the Add-In's macros. --Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with Calling a workbook | Excel Programming | |||
Problems calling macros in addin from within macros | Excel Programming | |||
Trouble calling macro | Excel Programming | |||
Calling Macros From VB6 | Excel Programming | |||
Calling macros from a VB app | Excel Programming |