Hello,

I have multiple excel files I wish to open in sequence. They all have
auto_open() macros so they update, save and close. My problem is that
when I put them in a batch file, all my excel files open at the same
time.

Any idea?

P.S.1 Calling different batch files from a main batch does not work.
The only thing the underlying batch has to do is start excel and when
it does, its job is done and the main batch goes on to the next
command.

P.S.2 I thought about delaying the second job with
PING 1.1.1.1 -n 1 -w 60000 NUL
but I'd have to know how long each of my files takes to update

On 23 May 2005 17:38:48 -0700, wrote in
microsoft.public.excel.programming and elsewhe

Hello,

I have multiple excel files I wish to open in sequence. They all have
auto_open() macros so they update, save and close. My problem is that
when I put them in a batch file, all my excel files open at the same
time.

Any idea?
[snip]

Try this:
START "" /WAIT book1.xls
START "" /WAIT book2.xls
etc.

See: START /? or, under NT5.1, paste this into your Start/Run... box:
ms-its:%windir%\Help\ntcmds.chm::/start.htm

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Thanks for the answer, unfortunately, START "" /WAIT does not work. The
Dos command is to start the excel file. Once it's done, the dos
command's job is done and it starts the second file.

On 24 May 2005 05:58:01 -0700, wrote in
microsoft.public.excel.programming:

Thanks for the answer, unfortunately, START "" /WAIT does not work. The
Dos command is to start the excel file. Once it's done, the dos
command's job is done and it starts the second file.

Which of the requirements above does the command sequence I suggested
fail? What does it do instead?

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

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.

On 25 May 2005 09:31:54 -0700, wrote in
microsoft.public.excel.programming:

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.

That's not how things work here (under NT5.1): here, I open the first
workbook - batch file sits and waits. I close the 1st workbook -
batchfile invokes the 2nd workbook and sits and waits. I close 2nd
workbook - batch file finishes.

Which operating system do you use and what's the auto_open VBA code?

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"