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