How to detect Excel version programmatically

Question

In my installer, I checked the registry key (HKEY_CLASSES_ROOT\Excel.Application\CurVer) to get version of Excel. It has worked since day 1. However, recently we find on one client's PC there is no such key and my installer fails. So I wonder if there is any other registry key to get version of Excel? Or the client's Excel has some issue?

Thanks

Edit

The client has office 2010 (32 bit), windows 7 (64 bit).

You don't provide any relevant details (Office version? OS?) on the failing PC, so it's difficult to make any suggestion. — Tim Williams
– Tim Williams, Commented Apr 21, 2014 at 21:48
oh, thanks for reminding. Updated the post with OS, office version — toosensitive
– toosensitive, Commented Apr 21, 2014 at 21:53
"Or the client's Excel has some issue?" - that's quite possible... — Tim Williams
– Tim Williams, Commented Apr 21, 2014 at 22:30

Gary's Student · Accepted Answer · 2014-04-21 23:10:53Z

1

Sub dural()
    MsgBox Application.Version
End Sub

Which on my machine yields 12.0 for Excel 2007

answered Apr 21, 2014 at 23:10

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ravi Yenugu · Accepted Answer · 2014-07-24 13:02:50Z

1

Using Application.Version

Sub Excel_Version()

Select Case (Val(Application.Version))

Case 8
        MsgBox "You use Excel 97"
Case 9
        MsgBox "You use Excel 2000"
Case 10
        MsgBox "You use Excel 2002"
Case 11
        MsgBox "You use Excel 2003"
Case 12
        MsgBox "You use Excel 2007"
Case 14
        MsgBox "You use Excel 2010"
Case 15
        MsgBox "You use Excel 2013"
End Select

    MsgBox "Welcome to Microsoft Excel version " & _
    Application.Version & " running on " & _
    Application.OperatingSystem & "!"

End Sub

answered Jul 24, 2014 at 13:02

Ravi Yenugu

3,8885 gold badges43 silver badges60 bronze badges

Collectives™ on Stack Overflow

How to detect Excel version programmatically

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related