Excel Version

[Heera]

Hi all,

With the help of a VBA code i want to find out the excel version(2003
or 2007) of the user so that i can execute a different codes as per
the version.

I used code "Application.Version" but the return value is 12 and I am
using excel 2007.

Please help................

Regards
Heera

 

[OssieMac]

Version 10 is xl2002
Version 11 is xl2003
Version 12 is xl2007

 

[Dave Peterson]

That's correct.

John Walkenbach shares the version numbers here:
http://spreadsheetpage.com/index.php/resource/excel_version_history/

if val(application.version) < 12 then

Some versions have a trailing letter.