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

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



<[email protected]> wrote in message
news:[email protected]...
>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
>

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" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>
>
> <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
>
>