| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to fire button in external file
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to fire button in external file
I am somewhat new to this. The functionality in File2 is tied to the button.
It's not a named macro. Is there anyway to 'activate' the button via a macro in File 1? thanks, "Barb Reinhardt" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Execute an external file in Active X control Button | Excel Programming | |||
| Macro to insert a hyperlink to external file | Excel Discussion (Misc queries) | |||
| Macro to fire upon opening file | Excel Discussion (Misc queries) | |||
| keypress to fire command button | Excel Programming | |||
| Use macro code from external xls file | Excel Programming | |||
Linear Mode
