Thread: Run macro from an excel file from another one
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
  
Posts: 1,120
Default Run macro from an excel file from another one
Application.Run "Workbook1.xls!Test"

--
HTH

Bob Phillips

"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


Reply With QuoteReply With Quote