_Synchro problem ... once again ...

[serge]

Still have no solution for this problem ... I start a program (*.exe) from within my VBA-module with Shell() ... The executable is starting but VBA is not waiting and is running the rest of the code ... Instead I want VBA to wait untill the *.exe stops. Has anybody did have the same problem ? Thanks ... SMD

[Ed__Jobe]

The Shell function is asyncronous. One way to accomplish this is to use the of External Command section of the pgp file. TheBit Flag argument set to '0' will achieve this. However, if your intention is to then run that new command from vba using SendCommand, remember that it too is asyncronous. -Ed

[Anonymous]

Check
href="http://www.vbdesign.net">www.vbdesign.net , Randall has a synchronous
shell module that we use daily.  It works like a champ!

--

Richard Binning
CADD Coordinator
The Haskell Company

href="http://www.thehaskellco.com">http://www.thehaskellco.com

 

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"Ed_Jobe" <eljobe> wrote in message
href="news:f0d9e2a.0@WebX.maYIadrTaRb">news:f0d9e2a.0@WebX.maYIadrTaRb...

The
Shell function is asyncronous. One way to accomplish this is to use the of
External Command section of the pgp file. TheBit Flag argument set to '0' will
achieve this. However, if your intention is to then run that new command from
vba using SendCommand, remember that it too is asyncronous.
-Ed