Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: George Evans   on Oct 18 In MS Office Category.

Is it possible to detect Excel version?


  
Question Answered By: Amelia Schmidt   on Oct 18

I have this code within my add-in, because of version  differences:

If Val(Application.Version) < 10 Then
Application.CalculateFull
Else
Application.CalculateFullRebuild
End If

You could probably use something similar. As far as I know:

< 8 then Excel 95 or earlier
= 8 then Excel 97
= 9 then Excel 2000
= 10 then Excel 2002 or XP
= 11 then Excel 2003
= 12 then Excel 2007

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Is it possible to detect Excel version? Or get search suggestion and latest updates.


Tagged: