Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"FILE" command on the tool bar is missing - how do I recover it | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
Removing "Save As" Command from an excel file. | Excel Worksheet Functions | |||
Excel VBA File Search Command Cannot "See" VBA Project Name | Excel Programming | |||
"Go ahead and replace file" command? | Excel Programming |