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

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

--
Regards,

OssieMac


"Heera" wrote:

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

That's correct.

John Walkenbach shares the version numbers he
http://spreadsheetpage.com/index.php...rsion_history/

if val(application.version) < 12 then

Some versions have a trailing letter.


Heera wrote:

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

--

Dave Peterson