Shell command and "BringWindowToT op! 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.ex e", vbHide
Shell "outlook.ex e", vbNormalFocus
Shell "outlook.ex e", vbMinimizedFocu s
Shell "outlook.ex e", vbMaximizedFocu s
Shell "outlook.ex e", vbNormalNoFocus
Shell "outlook.ex e", vbMinimizedNoFo cus

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 "BringWindowToT op" 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.c om...

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.ex e", vbHide
Shell "outlook.ex e", vbNormalFocus
Shell "outlook.ex e", vbMinimizedFocu s
Shell "outlook.ex e", vbMaximizedFocu s
Shell "outlook.ex e", vbNormalNoFocus
Shell "outlook.ex e", vbMinimizedNoFo cus

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 "BringWindowToT op" API --
with the same results.

Anyone have a clue what I'm overlooking?

Thanks to all who reply.

-- LW

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

After you execute the Shell command, call it with:
SetForegroundWi ndow Application.hWn dAccessApp