EXCEL VERSION & VBE FUNCTIONALITY
 

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 ... ?
--

Regards,

Halim

EXCEL VERSION & VBE FUNCTIONALITY
 

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)

"Halim" wrote in message
...
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 ... ?
--

Regards,

Halim

EXCEL VERSION & VBE FUNCTIONALITY
 

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/...p?ItemID=19#19

Regards,
Peter T

"Bob Phillips" wrote in message
...
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)

"Halim" wrote in message
...
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 ... ?
--

Regards,

Halim

EXCEL VERSION & VBE FUNCTIONALITY
 

Roedd <<Bob Phillips wedi ysgrifennu:

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 he

http://mc-computing.com/Databases/MS.../AddressOf.txt

Rob

EXCEL VERSION & VBE FUNCTIONALITY
 

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 ???


--

Regards,

Halim


"Bob Phillips" wrote:

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)

"Halim" wrote in message
...
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 ... ?
--

Regards,

Halim

EXCEL VERSION & VBE FUNCTIONALITY
 

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)

"Halim" wrote in message
...
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 ???


--

Regards,

Halim


"Bob Phillips" wrote:

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)

"Halim" wrote in message
...
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 ...
?
--

Regards,

Halim

EXCEL VERSION & VBE FUNCTIONALITY
 

Bob,

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

hgggggrrrr hhh ?? ???? ??

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

Regards,

Halim


"Bob Phillips" wrote:

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)

"Halim" wrote in message
...
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 ???


--

Regards,

Halim


"Bob Phillips" wrote:

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)

"Halim" wrote in message
...
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 ...
?
--

Regards,

Halim

EXCEL VERSION & VBE FUNCTIONALITY
 

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)

"Halim" wrote in message
...
Bob,

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

hgggggrrrr hhh ?? ???? ??

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

Regards,

Halim


"Bob Phillips" wrote:

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)

"Halim" wrote in message
...
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 ???


--

Regards,

Halim


"Bob Phillips" wrote:

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)

"Halim" wrote in message
...
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
....
?
--

Regards,

Halim