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
---------------------------------------------------------------
-