Hwnd Property of the Window Object in EXCEL 2010, 2007 ? (testers required)

[Jaafar Tribak]

Hi all,

Can anyone using excel 2007 or excel 2010 please confirm whether or not the Hwnd Property of the Window Object exists prior to excel 2013 (ie: prior to the introduction of the SDI interface)

Does the following compile in excel 2010,2007 ?

MsgBox ThisWorkBook.Windows(1).hwnd
MsgBox ActiveWindow.hwnd

I believe this hwnd property didn't exist prior to excel 2013 but I am not entirely sure.

Thanks for your help.

 

[RoryA]

I am 99% sure you are correct, but will see if I still have 2010 installed anywhere.

 

[ISY]

Hi

Comment obtenir le Handle (HWND) d'un contrôle - GethWnd - Contribuez

Cette question revenant régulièrement dans les affres du Net, je viens ici y répondre. Pour un UserForm, pas de souci, il suffit d'utiliser la fonction FindWindowA de la dll user32 de l'api Windows. Mais qu'en

www.developpez.net

 

[RoryA]

@ISY

I can't see how that link addresses the question?

 

[Jaafar Tribak]

@ISY

Thanks for the link but that is talking about retrieving the Hwnd of controls not workbook windows

@RoryA

So am I, as I don't remember ever seeing that Property before.
Thanks

 

[johnnyL]

Old Thread I realize.

I did test Excel 2007 32 bit and it errors.

Don't have 2010 to test.

 

[Rick Rothstein]

Application.hwnd exists, ThisWorkbook.hwnd does not exist in Excel 2010.

 

[johnnyL]

Ok new test:

Sub test()
'
' Excel 2007 32 bit / Windows 7 Results
'
'MsgBox ThisWorkbook.Windows(1).Hwnd             ' Error 438
'MsgBox Application.Windows(1).Hwnd              ' Error 438
'MsgBox ActiveWindow.Hwnd                        ' Error 438
'MsgBox Application.WorksheetFunction.Hwnd       ' Error 438
'MsgBox WorksheetFunction.Hwnd                   ' Error 438
MsgBox Application.Hwnd                         ' Results in 1311722
End Sub

Application.Hwnd does indeed yield a result in Excel 2007 32 bit Windows 7.