Get the name of the version

[Ben]

Hi,

When I used the Application.version it gave me a number
like 10.0, how I can get the corresponding name of the
the version like Excel 97, Excel 2002... ?

Thank you.

 

[Jim Rech]

There is no property that returns the full name of the product, as far as I
know. You could make your own little lookup/conversion routine as there are
not that many versions.

--
Jim Rech
Excel MVP
| Hi,
|
| When I used the Application.version it gave me a number
| like 10.0, how I can get the corresponding name of the
| the version like Excel 97, Excel 2002... ?
|
| Thank you.

 

[Ben]

Thank you Jim for the response,

I can't found the corresponding versions name to the
version number in the MSDN Library.

I have Excel 2002 installed and the version number is 10.
I have no idea about the other versions.

 

[Jim Rech]

Sorry..

http://www.j-walk.com/ss/excel/index.htm

--
Jim Rech
Excel MVP

| Thank you Jim for the response,
|
| I can't found the corresponding versions name to the
| version number in the MSDN Library.
|
| I have Excel 2002 installed and the version number is 10.
| I have no idea about the other versions.
|
|
| >-----Original Message-----
| >There is no property that returns the full name of the
| product, as far as I
| >know. You could make your own little lookup/conversion
| routine as there are
| >not that many versions.
| >
| >--
| >Jim Rech
| >Excel MVP
| >| >| Hi,
| >|
| >| When I used the Application.version it gave me a number
| >| like 10.0, how I can get the corresponding name of the
| >| the version like Excel 97, Excel 2002... ?
| >|
| >| Thank you.
| >
| >
| >.
| >

 

[Ron de Bruin]

Hi

http://www.j-walk.com/ss/excel/index.htm
You can find the numbers here

If Val(Application.Version) = 10 Then MsgBox "Excel 2002"

 

[Ben]

Thank you Jim and Ron.

That what I was looking for.