Can we know the Excel Version (2003 or 2007) thru code

[karan]

Hi All,

I have made a macro which has a couple of lines different for Excel 2003 and 2007. So, I have to maintain 2 different files for both the versions. I was wondering if I could use an If Loop in the code which could give me the Excel version there and then.

Let me know if you have any ideas?

Regards,
Karan

[DonkeyOte]

Yes, you can use:

Please Login or Register  to view this content.

12.0 being 2007 etc...

[karan]

and 11.0 being Excel 2003..

Thanks a lot for the quick response.

Regards,
Karan