You could easily change each file to run the macro by renaming each macro
Auto_Open.

In the control file, just create a macro that opens each then closes it

Workbooks.Open Filename:="A1.xls"
ACtiveworkbook.Close
etc.

--

HTH

RP

"Haim" wrote in message
...
Hi,

I have 3 very big Excel files and in each one of them
there is a macro writing in VB.

The files and there macro names:
File name Macro name
A1 ------------ Mac1
A2 ------------ Mac2
A3 ------------ Mac3

Because the files are ver
y big I am:
1. Opening one file at a time
2. Activate his macro
3. Save, close and open the next one and so on

My question:
From a different Excel file, can I activate the macro in
each one of the files (A1-A3)?
Meaning:
From a file call "Control"
The macro in this file will be:
- Open file A1
- Activate macro Mac1
- When finish, save and close the file
- Continue the same with files A2 and A3

How can I do that?
What will be the VB commands for the macro in
the "Control" file?


Thank you very much in advance,

Haim.