View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
 
Posts: 221
Default Run macro from an excel file from another one

Try this, Bruce:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=279
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Bruce" wrote in message
...
Is it possible to run a macro from an excel file via another one.

i.e. I have the files worksheet1 and workbook2. Workbook 2 has a macro
called test.

How do I call this from Workbook1?

Bruce