View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond Robin Hammond is offline
external usenet poster
 
Posts: 79
Default Run a macro of another workbook

Have a look at help on run.

sub test()
'open the other file
application.run "filename!macroname"
end sub

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Audie G. Bencosme R." wrote in message
...
Hello
Is it possible to open a book and make some of its macros run by code?, I
just can activate the macro editor in the macro i'm interest to run but i
can't make it run. My situation is like this: I have a workbook with a
button that opens another book which contain a macro i need to run in

order
to find a value but I can't figure how to make it run without inserting

the
code of that macro in my project code and repeat a code that is in the
workbook i just have opened.
Could someone help me, please