VBA Version Question

[kc270]

I am running Excel 2013 32 bit (version 15.0.4815.1002 on Windows 7 Professional 64 bit.

Several of our Excel files have VBA code in them to generate reports. These documents have existed for several years, and as the company switched to new versions of Excel, the Excel files were saved in the new versions.

My knowledge of Excel is limited. How do I determine which level or version of VBA is in these Excel files. Sorry for the basic question, but I could not find this information in the Excel file itself. I right clicked on the modules and selected "Project Properties", but nothing as far as VBA version was listed.

Any ideas on this would be appreciated - thanks.

 

[Rick Rothstein]

You can get the version number from the Application object...

MsgBox Application.Version

If it should ever matter to you, you can also get the Build number for that version as well...

MsgBox Application.Build

 

[kc270]

Do I create a Module and put that code in the Module?

 

[kc270]

Never mind, I figured it out, I was doing this

MsgBox Application.Version




But needed to enter it as this

Sub Version()

MsgBox Application.Version

End Sub

Thanks very much for the help.

Application Version returned 15.0. Does that mean this is VBA 15.0? The Build number returned was 4815.

 

[Rick Rothstein]

Application Version returned 15.0. Does that mean this is VBA 15.0? The Build number returned was 4815.

No, that is the application... Excel's... version and bulit numbers.

 

[kc270]

Is the VBA version tied to the Excel document version? So if a document began as Excel 2010, but was saved as Excel 2013, the VBA version is now Excel 2013. Would that be VBA 6?