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

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

CLng(Application.Version)

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

thanks

"MD" <demers_michelREMOVE@ifrance.commm> a écrit dans le message de news:
j1_oe.36405$Ab4.446720@weber.videotron.net...
> 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
>