EXCEL VERSION & VBE FUNCTIONALITY

[Guest]

Hi all,

I've ever seen from some developer and MVP's module that
commented about Application.Version, there explained which
version of Excel => 8 is have function:

Application.hwnd
AddressOf

But I never done use that function in my work office Excel V 9.0

Anyone done with the same version, please comment ...!
Which version of Excel has Application.hwnd and AddresOf function ... ?

 

[Bob Phillips]

The AddressOf came in in Excel 2000 (although it can be emulated with
Excel97, Version 8).

Application.hwnd property, came in in Excel XP/2002 (version 10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Peter T]

Just to add, if you need to return the application's window handle in
xl97/2000 following works for all versions

Public Declare Function FindWindow32 Lib "user32" _
Alias "FindWindowA" _
(ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long

Sub test()
Dim nHWind As Long
nHWnd = FindWindow32("XLMAIN", Application.Caption)
MsgBox nHWnd
End Sub

For the emulated AddressOf function for use in xl97 that Bob referred to
download "CallBack.xls" from the co-author's site -

http://www.trigeminal.com/lang/1033/codes.asp?ItemID=19#19

Regards,
Peter T

 

[Robert Bruce]

The AddressOf came in in Excel 2000 (although it can be emulated with
Excel97, Version 8).

Application.hwnd property, came in in Excel XP/2002 (version 10)

In earlier versions of Excel, the hwnd workaround was:

Private Declare Function FindWindow Lib "user32" _
Alias "FindWindowA" (ByVal _
lpClassName As String, ByVal _
lpWindowName As String) As Long

Function GetAppHWnd() As Long
Application.Caption = "__@" & CStr(Rnd())
GetAppHWnd = FindWindow("XLMAIN", Application.Caption)
Application.Caption = Empty
End Function

For the Addressof workaround in Office97 see here:

http://mc-computing.com/Databases/MSAccess/Code/AddressOf.txt

Rob

 

[Guest]

Hi Bob,

Thanks in advance...
but one more question that I want to know... is Why my Excel 2000 V9.0 doesnt
have Application.Hwnd property and AddressOf ???

 

[Bob Phillips]

It doesn't have hWnd because that cam in later than Excel 2000. However, it
should have AddressOf., my version certainly does.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Bob,

Don't know why my Excel V9.0 2000 doesnt have AddressOf and Application.hwnd
???

hgggggrrrr hhh ?? ???? ??

Is it commercial matter from microsoft ?!?!?!?

 

[Bob Phillips]

Not that I am aware of, as far as I know you should have AddressOf even in
Excel 2000.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)