Quite right, Peter!
Far too blinkered a view on my part.
(Might also help if I could spell "else")
--
Regards
Roger Govier

Peter T wrote:
... or with 2010 just around the corner

If Val(AppLication.version) = 12 Then

Regards,
Peter T


"Roger Govier" wrote in message
...
Hi

You need

If Val(Appication.version) = 12 Then
some code
Elae
Some other code
End if
--
Regards
Roger Govier

Subodh wrote:
I want to determine if the user has Excel Version 2007 or previous
one.
If the version is 2007 then i want to run one code
else the other one
I tried Application.version but it gave 12 as the version number for
Excel 2007
I want to do the following

If application version is 2007 then
......................
..............run this code
else if previous version
..........
............ run this code
end if