The diagnostic faithfully reports MS Office versions consistent with the post from 2011.
Wscript.Echo "Excel Version: " & excelApp.Version Set excelApp = CreateObject("Excel.Application") Here is a VB Script that diagnoses which, if any, version of Excel is installed to the system: On Error Resume Next Doug Glancy directly addressed the question with VB code that prints the version property of Excel Application object: For instance, the number 14.0 corresponded to Office 2010. Mathieu's reply, the accepted answer, correlated numbers used to identify MS Office in the registry versus the product versions. Identifying Excel version programmatically But now I find that it incorrectly reports MS Office 2019 applications as MS Office 2016.Įight years ago, M. It has worked correctly for MS Office versions 2003, 2007, 2010, 2013, and 2016. I maintain a diagnostic that programmatically determines the version of MS Office applications, including Excel and Word.
0 kommentar(er)
