Shell coding

[nbs]

Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 0)

Any reason why this opens in a full window instead of
being hidden as delared with the 0 variant (vbhide)?

Thanks

 

[Dave Peterson]

I have no idea--but why would you want to hide a application that needs to be
visible to be used?

If you just want it to show up on the taskbar, maybe you could activate your
excel window:

Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 4)
AppActivate Application.Caption


Actually, the calculator window is behind the activewindow--but it looks pretty
much the same to me.