Pass Version of Excel to a variable
 

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

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=26461

Pass Version of Excel to a variable
 

Hi ExcelMonkey,

Try:

Sub Test()
Dim strVersion As String
strVersion = Application.Version
MsgBox strVersion
End Sub

---
Regards,
Norman



"ExcelMonkey" wrote in message
...

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

Thnx


--
ExcelMonkey
------------------------------------------------------------------------
ExcelMonkey's Profile:
http://www.excelforum.com/member.php...fo&userid=5221
View this thread: http://www.excelforum.com/showthread...hreadid=264618