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