View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Haim[_2_] Haim[_2_] is offline
external usenet poster
 
Posts: 8
Default VB command in the "Control" file

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 very 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.