View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Subodh Subodh is offline
external usenet poster
 
Posts: 99
Default Determine if the Excel Version is 2007 or previous

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