View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pierrelap@gmail.com is offline
external usenet poster
 
Posts: 6
Default 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.