Re: run Shell with /wait

Allen -

Thanks very much for your response. I know you've been one of the Most
Valuable Players here for a long time, and I certainly appreciate your help

But really, isn't it time we just acknowledged that the Emperor has no
clothes? Why the hell shouldn't have the MS designers have recognized that
this is something that people want to do, and have built it in, instead of
having to have us jump through all the hoops we have to? I just heard, for
example. that vb.net has no Left or Right function. Have their designers
never had to develop an app? It's a typical example of why people like me
are gettting disgusted with MS. There are a thousand examples of how MS has
blown it in the past 30 years, changing things which worked in W/2k to things
which don't work in W/XP.

Believe me, this is not a diatribe at you, but because I think you may have
MS's ears, a diatribe to them. If they'd written their software right in the
first place, a lot of these support forums wouldn't be necessary. And it's
not because they're short of cash, they're just short of user wisdom, and
long on techs. Hey, ask anyone who deals with Word!

A thoroughly disgusted with MS, and eternally grateful to you..

Kevin (Who promises he won't write any more diatribes like this to you.)





"Allen Browne" wrote:

> See:
> API: Shell and Wait
> at:
> http://www.mvps.org/access/api/api0004.htm
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Kevin Witty" <kdw@xxxxxxxxxxxxxxxx> wrote in message
> news:566ABDCD-C876-41C6-9607-8DFE773A8D1E@xxxxxxxxxxxxxxxx
> > 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
>
>
>
.

Relevant Pages

  • Re: run Shell with /wait
    ... Kevin, you're very welcome to your opinion, and no offence taken. ... > MS's ears, a diatribe to them. ... >> API: Shell and Wait ... >>> runs after the Shell statement and tries to report the length of the ...
    (microsoft.public.access.modulesdaovba)
  • run Shell with /wait
    ... I'm creating a cmd file I want to run with Shell which copies an existing ... After the cmd file finishes, I want to report the length of the new file size ... and then proceed to the rest of the VBA code? ...
    (microsoft.public.access.modulesdaovba)
  • Re: run Shell with /wait
    ... API: Shell and Wait ... rather than allenbrowne at mvps dot org. ... > I'm creating a cmd file I want to run with Shell which copies an existing ... > runs after the Shell statement and tries to report the length of the file ...
    (microsoft.public.access.modulesdaovba)
  • Re: small black smoke/sound units
    ... I've posted a short clip of a daylight shell fired ... make great clouds of smoke .lampblack is just as messy but probably ... I have used finely powdered pigments with a flash bag burst ... good report in a siattene sized case. ...
    (rec.pyrotechnics)
  • Re: small black smoke/sound units
    ... I've posted a short clip of a daylight shell fired ... make great clouds of smoke .lampblack is just as messy but probably ...  I have used finely powdered pigments with a flash bag burst ... good report in a siattene sized case. ...
    (rec.pyrotechnics)