Identifying Excel version
 

Is there a way through code to identify, which version of
excel is in use?

then to use it in the following way

if excel version 8 do something
if excel version 9 do something
if excel version 10 do something
if excel version 11 do something

Thx

Identifying Excel version
 

Application.Version

Easy when you know how :)

Jeff

"Neil" wrote in message
...
Is there a way through code to identify, which version of
excel is in use?

then to use it in the following way

if excel version 8 do something
if excel version 9 do something
if excel version 10 do something
if excel version 11 do something

Thx

Identifying Excel version
 

Hi Neil;
Select Case Val(Application.Version)

MP

"Neil" a écrit dans le message de
...
Is there a way through code to identify, which version of
excel is in use?

then to use it in the following way

if excel version 8 do something
if excel version 9 do something
if excel version 10 do something
if excel version 11 do something

Thx