I keep a diagnostic that automatically determines the MS Office version, including Word and Excel. Versions of MS Office 2003, 2007, 2010, 2013, and 2016 have all run smoothly with it. However, I've since discovered that it incorrectly lists MS Office 2019 applications as MS Office 2016.
Here is a VB Script that diagnoses which, if any, version of Excel is installed to the system:
On Error Resume Next
Set excelApp = CreateObject("Excel.Application")
If Err.Number <> 0 Then
WScript.Echo "Excel is not installed"
Wscript.Echo "Excel Version: " & excelApp.Version
The diagnostic faithfully reports MS Office versions consistent with the post from 2011. Since then, it reports 15.0 for Office 2013, and 16.0 for Office 2016. Recently, though, I was surprised to find that it also reports 16.0 for Office 2019. That is just not right! The 2016 and 2019 feature sets are clearly distinct, so they should not be lumped together.
Is there an alternate way to programmatically distinguish Office 2016 from Office 2019?