[RESOLVED] Launch external app and wait

[jtruxxer]

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.

[bushmobile]

do a search for ShellAndWait.

For example, see #17 in this post

[jtruxxer]

Thanks for the quick reply!

[jtruxxer]

Hmm, I get an "invalid procedure call or argument" error at the

executionStatus = Shell(FileName, vbNormalFocus)

Line....

Am I missing something?

Forgive me it has been a long day...

Thanks

[bushmobile]

what is the value of 'filename' that you're passing to the procedure?

[jtruxxer]

Actually, I think that may be part of the problem...

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...

[bushmobile]

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?

[jtruxxer]

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!

[jtruxxer]

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!!!!!!!

[bushmobile]

Happens to the best of us

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

got enough of them in my own code thanks!

[d3gerald]

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

[jtruxxer]

Done! Thanks for the reminder