VB Forum / Win API / September 2003

If you know the Titles of these windows, use "FindWindow" to get a handle to
one of the windows.
If not, or they change... you may be able to use Spy++ or something similar
to find the Program Windows' Class Name, and then use that as the first
Parameter in FindWindow.

hWindow1 = FindWindow(vbNullString, "Bentley's MicroStation CADD")

Then all you need to do is use "SetWindowPos" with that Window's Handle.

SetWindowPos(Me.hWnd, hWindow1, 0, 0, 0, 0, SWP_NOACTIVATE or SWP_NOMOVE or
SWP_NOSIZE)

Now, not knowing how the program works makes it a bit difficult to get it to
appear above both windows.
Does the program bring both Windows to the top when you click one?
If so, the way I would do things would be to use the "GetWindow" function.

hWindow2 = FindWindow(vbNullString, "Bentley's MicroStation CADD Window 2")

First get a handle to the second window.

If GetWindow(hWindow1, GW_HWNDPREV) = hWindow2 Then

Now get the Window Handle that is above Window 1, and compare it to Window
2's Handle.
If they are the same, call SetWindowPos with hWindow2 instead of hWindow1.
That way it will stay above both Windows.

Check out the "GetWindowPlacement" function. The simplest way would be to
have a timer that checks when the window is minimised, and then minimise
your VB application.

That should happen if you maintain the Z-Order of your window properly with
the above code. I don't know if you can make your window stay in the
background when it is activated.

The Form itself has a property "ShowInTaskbar". Set it to False.
Not sure if VBA has that property though, probably not since it's pretty
obvious.

*chuckle* Good luck with that one.

You say you are writing a VBA program... are you writing you program in the
VB that is bundled inside of Microstation (in the "old" days, it was named
Microstation Basic, but I have a hunch it isn't referred to that way
anymore). If so, you should have a **rich** set of built-in functions and
subroutines available to you with which to control the entire Microstation
session. Do you have any documentation for the built-in Basic? Check the
written documentation (if they still distribute that), the CD or the Bentley
web site. I've not worked with Microstation for a few years now, so my
knowledge is only about the original form of Microstation Basic, but they
should not have changed it (function/subroutine-wise) too much since then.