View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CdSlc CdSlc is offline
external usenet poster
 
Posts: 8
Default 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.