Can I call an excel macro programmatically from another workbook in
Excel 2003?

For example suppose I have 2 workbooks, book1.xls and book2.xls:


book1.xls
module1
macro1

book2.xls
module2
macro2

How would I call book2.module2.macro2 from book1.module1.macro1?

Hi cr113

You can use Application.run

Application.Run "YourFile.xls!YourMacro"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"cr113" <(E-Mail Removed)> wrote in message news:156c1698-a01b-44f6-85f0-(E-Mail Removed)...
>
> Can I call an excel macro programmatically from another workbook in
> Excel 2003?
>
> For example suppose I have 2 workbooks, book1.xls and book2.xls:
>
>
> book1.xls
> module1
> macro1
>
> book2.xls
> module2
> macro2
>
> How would I call book2.module2.macro2 from book1.module1.macro1?

On Apr 1, 4:15*pm, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> Hi cr113
>
> You can use Application.run
>
> Application.Run "YourFile.xls!YourMacro"
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
>
>
> "cr113" <cr...@hotmail.com> wrote in messagenews:156c1698-a01b-44f6-85f0-(E-Mail Removed)...
>
> > Can I call an excel macro programmatically from another workbook in
> > Excel 2003?
>
> > For example suppose I have 2 workbooks, book1.xls and book2.xls:
>
> > book1.xls
> > * *module1
> > * * * *macro1
>
> > book2.xls
> > * *module2
> > * * * *macro2
>
> > How would I call book2.module2.macro2 from book1.module1.macro1?- Hide quoted text -
>
> - Show quoted text -

I had to do a workbooks.open "book2" first, but it worked.

Thanks!