AppActivate Syntax

[f64]

I am trying to use AppActivate to shift screen focus from Excel to a simulation program, SIMUL8, but I am having trouble debugging the statement. I have tried

AppActivate “SIMUL8”
and
AppActivate “nnnnnnnn SIMUL8”

(where nnnnnnnn is the model name) and I keep getting a “Run-time error ‘5’, Invalid procedure call or argument” message in VB. The title bar in SIMUL8 reads “nnnnnnnn SIMUL8”, so I think the second option should be correct. Anyone know what I’m doing wrong?

 

[PHV]

If your simulation program is launchend by VBA with the Shell function, you can use the task ID:
myTaskID=Shell(....)
AppActivate myTaskID

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884