Pass Version of Excel to a variable

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

How can you identify which version of excel you are currently in whil
in VBA? Is it possible to pass this to a variable and then to
message box to infom the user?

Thn
 
Hi ExcelMonkey,

Try:

Sub Test()
Dim strVersion As String
strVersion = Application.Version
MsgBox strVersion
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing the Value of a Cell to a VBA variable. 2
Access variable from form and module? 1
Pass value variable to worksheet event 3
How to create a bubble chart with more than 2 variables 0
Passing a variable from sheet code to a module 2
Web Queries : Passing variables via POST method not working 2
Possible to pass a variable to Excel from command line/short cut? 2
Simple Variable to someone 5

Back
Top