Using Shell to open and hide an application

[rapsr59]

The shell command can open an application and hide it.

lngAppID = Shell(strApplication, vbHide)

lngAppID is the numeric value that is returned that references the application that was opened. By keeping track of this value, the AppActivate command can activate the application using lngAppID in it’s Title argument.

Example:
AppActivate lngAppID


Using VBA…

How can I check if the Hidden application is in memory?

Once I’ve checked it’s in memory, how can the application be “UnHidden”, and activated?

Once “UnHidden”, and activated, how can I Re-hide the application?

Have fun with this one!


Richard

 

[rapsr59]

I forgot to mention...

If the application is not hidden.

Using AppActivate lngAppID will activate the application and set focus on the application.

Sorry...


Richard