Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
Hi,
I have to write some specific code for Excel 2007, so I need to know what version of Excel my macros are running under. Can anybody please let me know how to find the Excel version using Excel 4.0 macro? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
=GET.WORKSPACE(2)
-- Jim "CdSlc" wrote in message ... | Hi, | | I have to write some specific code for Excel 2007, so I need to know what | version of Excel my macros are running under. Can anybody please let me know | how to find the Excel version using Excel 4.0 macro? | | Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
Hi
GET.WORKSPACE(2) Will return the Excel version as text (eg "11.0" for Excel 2003) HTH Cordially Pascal "CdSlc" a écrit dans le message de news: ... Hi, I have to write some specific code for Excel 2007, so I need to know what version of Excel my macros are running under. Can anybody please let me know how to find the Excel version using Excel 4.0 macro? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
Thank you, Jim. Thank you very much. You da man!!!!
I searched for this issue of getting Excel version in Excel macro help file, did not find anything. Never, never in my wildest dream would I have thought about checking in GET.WORKSPACE. Did google and found lots of VBA help but nothing about 4.0 macro. I have posted Excel 4.0 macro questions at other forums and nobody has any answer for it. Maybe both of us are the only last two person in this whole wide world who still uses Excel 4.0 macro. Once again, thank you very much for your help. "Jim Rech" wrote: =GET.WORKSPACE(2) -- Jim "CdSlc" wrote in message ... | Hi, | | I have to write some specific code for Excel 2007, so I need to know what | version of Excel my macros are running under. Can anybody please let me know | how to find the Excel version using Excel 4.0 macro? | | Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
Thanks Pascal for your help.
Now one more dumb question... In Excel 4.0 macro, I have written this command like "ExcelVersionString=GET.WORKSPACE(2)". In the variable "ExcelVersionString", I have a string value "10.0" or "11.0" or "12.0", etc. Now, how do I convert this string to an integer and store it in a variable say "ExcelVersionInteger" so that I can just do an "if ExcelVersionInteger 11" kind of comparison? Thanks. "papou" wrote: Hi GET.WORKSPACE(2) Will return the Excel version as text (eg "11.0" for Excel 2003) HTH Cordially Pascal "CdSlc" a écrit dans le message de news: ... Hi, I have to write some specific code for Excel 2007, so I need to know what version of Excel my macros are running under. Can anybody please let me know how to find the Excel version using Excel 4.0 macro? Thanks. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
ExcelVersionNumber=VALUE(GET.WORKSPACE(2))
-- Jim "CdSlc" wrote in message ... | Thanks Pascal for your help. | | Now one more dumb question... | In Excel 4.0 macro, I have written this command like | "ExcelVersionString=GET.WORKSPACE(2)". In the variable "ExcelVersionString", | I have a string value "10.0" or "11.0" or "12.0", etc. Now, how do I convert | this string to an integer and store it in a variable say | "ExcelVersionInteger" so that I can just do an "if ExcelVersionInteger 11" | kind of comparison? | | Thanks. | | "papou" wrote: | | Hi | GET.WORKSPACE(2) | | Will return the Excel version as text (eg "11.0" for Excel 2003) | | HTH | Cordially | Pascal | | "CdSlc" a écrit dans le message de news: | ... | Hi, | | I have to write some specific code for Excel 2007, so I need to know what | version of Excel my macros are running under. Can anybody please let me | know | how to find the Excel version using Excel 4.0 macro? | | Thanks. | | | |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
Thanks a lot, Jim for your very quick response. You have been a life-saver.
As you can see from my question, I am a total rookie with Excel 4 macros. I am just trying to make an application written like ages ago, to run on Excel 2007 with minimal code changes. "Jim Rech" wrote: ExcelVersionNumber=VALUE(GET.WORKSPACE(2)) -- Jim "CdSlc" wrote in message ... | Thanks Pascal for your help. | | Now one more dumb question... | In Excel 4.0 macro, I have written this command like | "ExcelVersionString=GET.WORKSPACE(2)". In the variable "ExcelVersionString", | I have a string value "10.0" or "11.0" or "12.0", etc. Now, how do I convert | this string to an integer and store it in a variable say | "ExcelVersionInteger" so that I can just do an "if ExcelVersionInteger 11" | kind of comparison? | | Thanks. | | "papou" wrote: | | Hi | GET.WORKSPACE(2) | | Will return the Excel version as text (eg "11.0" for Excel 2003) | | HTH | Cordially | Pascal | | "CdSlc" a écrit dans le message de news: | ... | Hi, | | I have to write some specific code for Excel 2007, so I need to know what | version of Excel my macros are running under. Can anybody please let me | know | how to find the Excel version using Excel 4.0 macro? | | Thanks. | | | |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Excel version using Excel 4.0 Macro.
Thanks a lot, Pascal for the link. I have downloaded that file and will go
through it. "papou" wrote: In addition: Since you seem to be working a little on Excel4 macros, I would suggest you try and find for download the Macro Help file (XLMACR8.HLP), this will provide you with all available Excel4 macro functions. http://support.microsoft.com/kb/143466 HTH Cordially Pascal "CdSlc" a écrit dans le message de news: ... Thanks Pascal for your help. Now one more dumb question... In Excel 4.0 macro, I have written this command like "ExcelVersionString=GET.WORKSPACE(2)". In the variable "ExcelVersionString", I have a string value "10.0" or "11.0" or "12.0", etc. Now, how do I convert this string to an integer and store it in a variable say "ExcelVersionInteger" so that I can just do an "if ExcelVersionInteger 11" kind of comparison? Thanks. "papou" wrote: Hi GET.WORKSPACE(2) Will return the Excel version as text (eg "11.0" for Excel 2003) HTH Cordially Pascal "CdSlc" a écrit dans le message de news: ... Hi, I have to write some specific code for Excel 2007, so I need to know what version of Excel my macros are running under. Can anybody please let me know how to find the Excel version using Excel 4.0 macro? Thanks. |
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) | |||
Modify Macro Code Depending on Excel Version | Excel Discussion (Misc queries) | |||
Macro - Save an Open Excel Version 4 as current version of Excel | Excel Programming | |||
Type of macro (Excel Version 4) that cannot be disabled? | Excel Programming | |||
Finding which version of Excel created a file | Excel Programming |