Macro to fire button in external file

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

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?
 
Why can't you just run the macro in File2 from File 1

I believe the syntax is

Application.Run ("File2.xls!Macro1")
 
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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call Excel add-in macro from a button… 1
i need 1 macro button in master file to refresh data from all files 0
How to Unlock Excel Workbook protected by MACRO Password 6
Log to a file everytime I open a spreadsheet 1
Assigning macro buttons to macro code in another file 2
User can't see Input boxes 3
how to run a recorded macro in many files at a same time 1
Command Button Question 8

Back
Top