VBA to run BAT sequentially every 1 minute

[jaime1182]

Hi brains trust

I was wondering if someone could help me.

I have a folder with over 30 batch files.

I need to run them in order but with a 2 minute wait time between running the batch files.

I understand I could do this:

shell("CMD.EXE /c c:\abc.bat")

This might make things tricky as I would have to write in all the batch file names

I am sure there is a smarter and faster way of doing this. I would appreciate any help!

 

[James006]

Hi,
If all your files are located in a given specific folder, why not using a Loop ( For each ... Next )