Batch file to start multiple excel files with auto_open() macro. Delay code needed
Hello,
This is what I have in my batch file (as suggested by you):
path C:\
START "" /WAIT autoopen.xls
START "" /WAIT autoopen2.xls
The autoopen.xls and autoopen2.xls files have auto_open() macros that
start an update macro, and another one that saves and exit.
The batch file gou suggested starts both files one after another. In
other words, I have two excel files that update at the same time. The
wait command is only telling dos to wait until the file is opened.
After it is opened, it goes on even though the update, save, close
procedure is not finished.
What I need is to prevent having two files updating at the same time.
|