check Excel version to run code

[hmk]

Hi there

IF I install two versions of Excel App one is 9 and the other is 11
Dos this code work......


Code:
IF val(Application.Version) =11 Then
My Code
Else
Exit Sub

Do u think i need to use search method to search for version 11 first and open it then run the code..........if yes, would u pls what is the code to search for the excel version?

------------------------------------
Another problem : when i post a thread and got an answer, i do not receive an email notification that there is a reply on my thread
how can i solve it ?

 

[Oaktree]

The code, as you have written it, should work fine.

 

[hmk]

THank u Oaktree

what is the problem in the second quiry ? (Thank u)

 

[Oaktree]

There is a checkbox for "notify me when a reply is posted" when you submit a post.

 

[hmk]

Oaktree, thank u..............but i did checked it with no result

in fact when posting this thread 2 u , it was checked

any idea why ut does not work?