View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Running external programs

Googling for ShellAndWait finds a few more than ShellWait. (I didn't compare
the results, though--they could be the same routine.



Alan Beban wrote:

Thanks to Rob van Gelder and Dave Peterson.

Alan Beban

Rob van Gelder wrote:
VBA's shell command will continue execution immediately after the executable
has launched.
Do a Google Search for: VBA ShellWait to get VBA to wait for the process to
terminate.


"Alan Beban" wrote in message
...

A friend is asking "How do I run an external .exe or .cmd file from
Excel?" Is that a meaningful question without more?

TIA,
Alan Beban





--

Dave Peterson