vba to loop until program closed...

C

chris_culley

Hi,

I'm not so hot on DOS commands so thought I'd better consult!

I'm launching an application from vba then instructing it to run it's
own script as follows:

***

Set oSplus = CreateObject("S-PLUS.Application")
oSplus.executestring ("source(""c:\\" & scriptToRun & """,
echo=T)")

***

The script that the application ( splus) runs takes a looong time at
the end of which S plus closes. I want the launching vba to wait until
excel closes (i.e, sit in a loop for a while) before continuing in
its own execution.

Not sure how to do this - any pointers would be greatfully recieved...

Many thanks

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba to loop until process finished 3
How to Pause an Excel VBA script without freezing excel 1
calling sql loader from vba 1
how to get vba to wait until a shell command has completed 3
vbs script to launch secure Access database 8
VBA Editor Keeps Opening On Its Own-Outlook 07 0
Clipboard macro seriously locks up (or whatever it does) myclipboard! [XL2003] 1
General Question about Macros 1

Top