Thread: Macro to fire button in external file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Macro to fire button in external file
Why can't you just run the macro in File2 from File 1

I believe the syntax is

Application.Run ("File2.xls!Macro1")

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"JB" wrote:

I have two files...I have a macro in file #1 that I need to 'click' a button
(to run a macro) in file #2. Any suggestions?
Reply With QuoteReply With Quote