Thread
:
Finding Excel version using Excel 4.0 Macro.
View Single Post
#
9
Posted to microsoft.public.excel.programming
CdSlc
external usenet poster
Posts: 8
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 With Quote
CdSlc
View Public Profile
Find all posts by CdSlc