Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving a newer version of Excel using an older version (Excel 97) | Excel Discussion (Misc queries) | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
OS Version impact on Excel functionality | Excel Worksheet Functions | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) |