how to get hwnd from application object?

  • Thread starter Thread starter Erwin Kalvelagen
  • Start date Start date
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
 
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
 
Ah, great, that explains it. I am running good old Excel 2000.
Thanks for the explanation!
 
Back
Top