Shell command and "BringWindowToTop! trouble. ANY advice welcome!

[VRWC]

Hello dear people,

In an A2K app, I have attempted to use the following command in some
VBA code with IDENTICAL results with every single version of the
following:

Shell "outlook.exe", vbHide
Shell "outlook.exe", vbNormalFocus
Shell "outlook.exe", vbMinimizedFocus
Shell "outlook.exe", vbMaximizedFocus
Shell "outlook.exe", vbNormalNoFocus
Shell "outlook.exe", vbMinimizedNoFocus

In every instance above, Outlook loads, displays the Outlook window
and just stays there! All I want to do is to load Outlook in the
background and stay focused on the form from which the command
was issued.

IOW -- the command arguments simply do not work as documented.

Thanks to Tom, I have now even tried the "BringWindowToTop" API --
with the same results.

Anyone have a clue what I'm overlooking?

Thanks to all who reply.

-- LW

[ByteMyzer]

"VRWC" <pr*****@nospam.com> wrote in message
news:aq********************************@4ax.com...

Hello dear people,

In an A2K app, I have attempted to use the following command in some
VBA code with IDENTICAL results with every single version of the
following:

Shell "outlook.exe", vbHide
Shell "outlook.exe", vbNormalFocus
Shell "outlook.exe", vbMinimizedFocus
Shell "outlook.exe", vbMaximizedFocus
Shell "outlook.exe", vbNormalNoFocus
Shell "outlook.exe", vbMinimizedNoFocus

In every instance above, Outlook loads, displays the Outlook window
and just stays there! All I want to do is to load Outlook in the
background and stay focused on the form from which the command
was issued.

IOW -- the command arguments simply do not work as documented.

Thanks to Tom, I have now even tried the "BringWindowToTop" API --
with the same results.

Anyone have a clue what I'm overlooking?

Thanks to all who reply.

-- LW

Have you tried the SetForegroundWindow API? Here is the VB Declaration
Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long)
As Long

After you execute the Shell command, call it with:
SetForegroundWindow Application.hWndAccessApp