From String to Long
 

Hello,

As I ask for the Application.Version ,I will get a string type variable
answer ("10.0" for excel XP). I would like to test if the user has a
version 10.0 or more. So I need to covert my String into a Long type of
variable in order to do a logic test... Or is there another way to it??

any suggestions?

regards,

MD

From String to Long
 

Just use Val(Application.Version)=10

"MD" wrote:

Hello,

As I ask for the Application.Version ,I will get a string type variable
answer ("10.0" for excel XP). I would like to test if the user has a
version 10.0 or more. So I need to covert my String into a Long type of
variable in order to do a logic test... Or is there another way to it??

any suggestions?

regards,

MD

From String to Long
 

CLng(Application.Version)

From String to Long
 

I know.... I had a blonde moment just put Val !!! LOL

thanks

"MD" a écrit dans le message de news:
...
Hello,

As I ask for the Application.Version ,I will get a string type variable
answer ("10.0" for excel XP). I would like to test if the user has a
version 10.0 or more. So I need to covert my String into a Long type of
variable in order to do a logic test... Or is there another way to it??

any suggestions?

regards,

MD