VB Macro to run multiple macro in time interval

[rizmomin]

Hello:

I have to run quite a few excel VB macro every morning one after the other.
I have to manually go thru each of them.
i need to create 1 VB macro which will run all macro after 1 min of interval in between.

Example:

Macro to run Sub Store1
Wait 1 min and then run Macro for Store2.
Macro to run Sub Store2
Wait 1 min and then run Macro for Store3.
Macro to run Sub Store3 and so on.

Below is the code I started with but not sucessful.

Please Login or Register  to view this content.

Let me Know if you have any questions.
Thanks.

[schmagekie]

Please Login or Register  to view this content.

[rizmomin]

Hello Schmagekie:

Thank you for your help.
However, I would like to modify the above code so that when I run this macro, it will run the macro Sub Store1 and open the file for Store1.
Then I would have to do certain things in this Store1 file and it would prob take me nearly 1 min and I will save and close.
By this time the macro needs to run Sub Store2 macro which will open the file for Store2 and same like for Store1...

Let me Know if you have any questions.
Thanks.



Riz