how to get hwnd from application object?

E

Erwin Kalvelagen

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
 
C

Chip Pearson

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
 
E

Erwin Kalvelagen

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