VBA Version Numbers

Question

I have been able to find the Excel version number as follows:

Dim strAppVersion As String

strAppVersion = Application.Version

I believe they can be cross-referenced as follows:

A simple case entry would return a user-friendly reply.

5 = Excel 5

6 = Excel 6

7 = Excel 95

8 = Excel 97

9 = Excel 2000

10 = Excel 2002

11 = Excel 2003

12 = Excel 2007

14 = Excel 2010

15 = Excel 2013

But what about the Visual Basic version?

Are they released in pairs? If so, can anyone complete the table for me?

I am using Excel 2003 and VB 6.5

How can I code VBA to return its own version number?

Answer 1

EXcel 2003 for me.

 

I pasted your code into a new empty module.

 

Method 'VBE' of object 'Application' failed.

In excel 2003 while on a worksheet i.e. not in VB editor try this

Tools | Options | Security tab | Macro Security | Trusted Publishers tab and Check 'Trust access to visual basic project' and then try the code again.

Answer 2

EXcel 2003 for me.

I pasted your code into a new empty module.

Method 'VBE' of object 'Application' failed.

Answer 3

That's strange, it works fine for me with XL2003

Answer 4

Sorry,

Returns a 'Run-Time Error'.

Answer 5

HI

Try this:

Sub cc()

Dim strAppVersion As String

 strAppVersion = Application.VBE.Version

MsgBox strAppVersion

End Sub