So how can we check the application version in modern Office?Īfter doing a little digging, I finally found a registry key that seems to appear in Office 2019 and Office 365, but does not exist in Office 2016. I needed to find a way to programatically enumerate whether a user is running Office 2016, Office 2019 or Office 365, as I had to do something different in each case. This past week I ran into a scenario where I needed to do exactly this. As there are now things that work differently for Office 365 than the perpetual licenses, this is another potential problem for developers. (Bastien discusses this i n a blog post a few months ago.) But worse, while he focuses on 2016 vs 2019, there is also no way to test between these and Office 365 subscription versions. From Office 2016 onwards, Microsoft has not revved the Application.Version number - they all show as 16.0 - giving you no way to differentiate between versions. But then Office 365 came out, and 2019, and things fell apart.Ĭonducting a check of the application version in Modern Office is not as straight forward. You just used a little test of Val(Application.Version) to return the number.

In the good old days, it was easy to check the application version in Office with VBA.

Difference between office 2016 and 2019