MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Version info from macro

Posted by Christopher Patrick on September 17, 2001 8:01 AM

Hi again-

One more question. Is there a way to get the version of Excel (97 or 2000) from a macro.

Thanks again


Posted by Russell Hauf on September 17, 2001 8:08 AM


Excel 2000 will be 9.0, and 97 will be 8.0x (where x on my '97 version is "e").

Posted by JAF on September 17, 2001 8:10 AM


Sub get_version()
Dim version_number
version_number = Application.Version
MsgBox version_number
End Sub

Will return the NUMBER of the version number - e.g. Excel 2000 for Windows is Version 9