View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default 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