ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Window Handle (https://www.excelbanter.com/excel-programming/327746-window-handle.html)

pod

Window Handle
 
How can I find the window handle for my Excel session from within VBA?

Tom Ogilvy

Window Handle
 
? application.hwnd
66358


in Excel 2000 and later (or perhaps xl2002 or later - can't recall for
sure).

--
Regards,
Tom Ogilvy

"pod" wrote in message
...
How can I find the window handle for my Excel session from within VBA?




Rob Bovey

Window Handle
 
"Tom Ogilvy" wrote in message
...
? application.hwnd
66358


in Excel 2000 and later (or perhaps xl2002 or later - can't recall for
sure).


It's Excel 2002 or later. Excel 97/2000 would require a FindWindow API
call.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm




All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com