HI,
There is a file "C:\CALCULATIONS\FINALGRAND EVALUATIONS.xlsm". I would like to have a code in this file which, opens 5 different files and also runs a macro saved in each of them simultaneously. The paths for those files are stated below.
- C:\CALCULATIONS\FIRST\GRAND EVALUATIONS.xlsm
- C:\CALCULATIONS\FIRST - Copy\GRAND EVALUATIONS.xlsm
- C:\CALCULATIONS\FIRST - Copy (2)\GRAND EVALUATIONS.xlsm
- C:\CALCULATIONS\FIRST - Copy (3)\GRAND EVALUATIONS.xlsm
- C:\CALCULATIONS\FIRST - Copy (4)\GRAND EVALUATIONS.xlsm
At first the code in "C:\CALCULATIONS\FINALGRAND EVALUATIONS.xlsm" should open "C:\CALCULATIONS\FIRST\GRAND EVALUATIONS.xlsm", then it should run a macro in it. The name of that macro is "CommandButton1_Click()".
When the first macro has finished running "C:\CALCULATIONS\FIRST - Copy\GRAND EVALUATIONS.xlsm" should be opened and a macro in it runs.The name of that macro is "CommandButton1_Click()"
When the second macro has finished running "C:\CALCULATIONS\FIRST - Copy (2)\GRAND EVALUATIONS.xlsm" should be opened and a macro in it runs. The name of that macro is "CommandButton1_Click()"
When the third macro has finished running "C:\CALCULATIONS\FIRST - Copy (3)\GRAND EVALUATIONS.xlsm" should be opened and a macro in it runs. The name of that macro is "CommandButton1_Click()"
When the fourth macro has finished running "C:\CALCULATIONS\FIRST - Copy (4)\GRAND EVALUATIONS.xlsm" should be opened and a macro in it runs. The name of that macro is "CommandButton1_Click()"
At last, The file "C:\CALCULATIONS\FINALGRAND EVALUATIONS.xlsm" saves and closes itself.
Thank you
Bookmarks