| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
From String to Long
CLng(Application.Version)
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Long string of IF formulas | Excel Discussion (Misc queries) | |||
| Get long value for a date string | Excel Programming | |||
| Transposing a Long String | Excel Worksheet Functions | |||
| converting a string to long | Excel Programming | |||
| Type mismatch? string 2 a long?? | Excel Programming | |||
Linear Mode
