Thread: how to get hwnd from application object?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default how to get hwnd from application object?
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
---------------------------------------------------------------
-





Reply With QuoteReply With Quote