run Shell with /wait
- From: "Kevin Witty" <kdw@xxxxxxxxxxxxxxxx>
- Date: Fri, 13 May 2005 19:06:02 -0700
I'm creating a cmd file I want to run with Shell which copies an existing
file, performs an operation on it which will change the file size, and then
deletes the original and saves the new file back with the old file name.
After the cmd file finishes, I want to report the length of the new file size
using FileLen.
By default, Shell executes asynchronously, which means my VBA code which
runs after the Shell statement and tries to report the length of the file
created using FileLen, fails. It reports the size of the original file.
I've tried using /wait in the cmd file which runs, but that hasn't helped.
Is there a way to make Shell Wait until the operation it started finishes,
and then proceed to the rest of the VBA code?
Thanks,
Kevin
.
- Follow-Ups:
- Re: run Shell with /wait
- From: Allen Browne
- Re: run Shell with /wait
- Prev by Date: Values same table for 68 Q yes=+, No=-, U=0, 75 Q yes=-, no=+
- Next by Date: Re: Registry functions
- Previous by thread: Values same table for 68 Q yes=+, No=-, U=0, 75 Q yes=-, no=+
- Next by thread: Re: run Shell with /wait
- Index(es):
Relevant Pages
|
Loading
