Call Shell(...) - wait until app ends

[itazev]

Hey guys!

just wondering if there is an way to command

Call Shell("my_bakcup_string",1)

and wait 'till the bakcup program ends to go next command in VBA

thank you!

 

[boblarson]

Here's something I found using Google and the search terms "VBA Shell and Wait"
http://www.appspro.com/Tips/VBA Tips.htm

 

[boblarson]

And here's one from this forum:
http://www.access-programmers.co.uk/forums/showthread.php?t=115545&highlight=Shell+wait

The search function really does work on this website (just play around with the search terms)

 

[itazev]

shame on me

Shame on me!
Sorry guys, I should tried a search before posting!
But thank you!
I'll check out the links!

 

[RuralGuy]

There is also code from gemma-the-husky in this thread that I have implemented and it works well.