[RESOLVED] Launch external app and wait

Printable View

Mar 6th, 2006, 05:36 PM
jtruxxer

[RESOLVED] Launch external app and wait

Hi,

I can shell execute a programme, but I want to wait until that program is finished running before continuing on to the next line of code, is this possible?

Thanks in advance.
Mar 6th, 2006, 05:42 PM
bushmobile

Re: Launch external app and wait

do a search for ShellAndWait.

For example, see #17 in this post
Mar 6th, 2006, 05:43 PM
jtruxxer

Re: Launch external app and wait

Thanks for the quick reply!
Mar 6th, 2006, 06:24 PM
jtruxxer

Re: Launch external app and wait
Hmm, I get an "invalid procedure call or argument" error at the
VB Code:
```
executionStatus = Shell(FileName, vbNormalFocus)
```
Line....

Am I missing something?

Forgive me it has been a long day...

Thanks
Mar 6th, 2006, 06:30 PM
bushmobile

Re: Launch external app and wait

what is the value of 'filename' that you're passing to the procedure?
Mar 6th, 2006, 07:13 PM
jtruxxer

Re: Launch external app and wait
Actually, I think that may be part of the problem...
VB Code:
```
fileName = AppPath & "\files\MSDE\SqlRun16.msi disablenetworkprotocols=0 blanksapwd=1 securitymode=sql instancename=_T7DEMO_DB"
```
I think it's the command line parameters that are messing it up... I thought I might be able to get away with including them as part of the string...

any suggestions?

Main reason Im doing this is as a front end for my installer, since i seem to be failing miserably with InstallShield 11 and getting it to install the MSDE first before prompting for SQL login....

Thanks alot for the help...
Mar 6th, 2006, 07:28 PM
bushmobile

Re: Launch external app and wait

I just did a little test and I had no problems passing cmd line parameters.

Just to check, is AppPath a typo? It should be App.Path

Have you tried getting it to work without passing the parameters?
Mar 6th, 2006, 07:34 PM
jtruxxer

Re: Launch external app and wait

Yeah, a typo ( I manually typed the code here) but now that you mention it.........

Ill have to look into the code again. Im at home now, I'll VPN into my computer at work and take a look. No doubt I typo'd it in the code as well....

What a long day it has been!

Thanks!
Mar 6th, 2006, 08:01 PM
jtruxxer

Re: Launch external app and wait

:blush: :blush: :blush: :blush: :blush: :blush:

You hit the nail on the head, Bushmobile!

I missed the period in app.path

works like a charm!

Thanks again for all your help.... maybe I should enlist you to proof read my code for typo's!!!!!!! :D
Mar 6th, 2006, 08:08 PM
bushmobile

Re: Launch external app and wait

Quote:

Originally Posted by jtruxxer

:blush: :blush: :blush: :blush: :blush: :blush:

Happens to the best of us ;)

Quote:

maybe I should enlist you to proof read my code for typo's!!!!!!!

:eek2: got enough of them in my own code thanks! :D
Mar 6th, 2006, 08:09 PM
d3gerald

Re: Launch external app and wait

This thread has been resolved if i'm not mistaken, so lets help the mods by marking this as Resolved. see instruction in my signature
Mar 6th, 2006, 08:14 PM
jtruxxer

Re: [RESOLVED] Launch external app and wait

Done! Thanks for the reminder ;)