Hi:

I am using Excel from another app using COM/OLE. I need
to bring the Excel window to the foreground. Is there any way
to the hWnd from the Application object? Now I use the
FindWindow API call to find the Excel window
but that is not foolproof.

Thanks, Erwin


----------------------------------------------------------------
Erwin Kalvelagen
GAMS Development Corp., http://www.gams.com
, http://www.gams.com/~erwin
----------------------------------------------------------------

Erwin,

In Excel 2002 and later, you can get the hWnd property directly
from the Application object. E.g.,

Dim XLHWnd As Long
XLHWnd = Application.Hwnd

In earlier versions, you need to use FindWindow on "XLMAIN".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Erwin Kalvelagen" wrote in message
...

Hi:

I am using Excel from another app using COM/OLE. I need
to bring the Excel window to the foreground. Is there any way
to the hWnd from the Application object? Now I use the
FindWindow API call to find the Excel window
but that is not foolproof.

Thanks, Erwin


---------------------------------------------------------------
-
Erwin Kalvelagen
GAMS Development Corp., http://www.gams.com
, http://www.gams.com/~erwin
---------------------------------------------------------------
-

Ah, great, that explains it. I am running good old Excel 2000.
Thanks for the explanation!

--
----------------------------------------------------------------
Erwin Kalvelagen
GAMS Development Corp., http://www.gams.com
, http://www.gams.com/~erwin
----------------------------------------------------------------


"Chip Pearson" wrote in message ...
Erwin,

In Excel 2002 and later, you can get the hWnd property directly
from the Application object. E.g.,

Dim XLHWnd As Long
XLHWnd = Application.Hwnd

In earlier versions, you need to use FindWindow on "XLMAIN".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Erwin Kalvelagen" wrote in message
...

Hi:

I am using Excel from another app using COM/OLE. I need
to bring the Excel window to the foreground. Is there any way
to the hWnd from the Application object? Now I use the
FindWindow API call to find the Excel window
but that is not foolproof.

Thanks, Erwin


---------------------------------------------------------------
-
Erwin Kalvelagen
GAMS Development Corp., http://www.gams.com
, http://www.gams.com/~erwin
---------------------------------------------------------------
-