Finding Version of OFFICE 365 Build version with MS-Access VBA-CodePudding

With Microsoft's latest forced update to Office 365 that

or,

About Access in Apps For Business

From VBA I can get the following

Debug.Print Application.Version & "." & Application.Build & vbcrlf & Application.ProductCode
16.0.8326 
{90160000-000F-0000-0000-0000000FF1CE}

Looking at the properties of MSAccess.exe only shows the same app versions

EDIT

No luck with registry setting either

Looking at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration only shows

CurrentVersionToReport=16.0.8326.2096

CodePudding user response：

You can map the build to the version. They're the same thing.

You've already figured out how to get the build number, Application.Build.

You can map that using the table provided on Microsoft Docs: https://docs.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date.

The version is just a shorter code, and thus more easy to memorize and communicate (and minor changes can result in different build numbers but identical version numbers).

CodePudding user response：

This is, unfortunately, not a trivial task, but Colin made a serious attempt:

Access / Office 365 / Windows Version Check

Version 2.55. Updated 26/11/2021

Attached is a utility for checking the following: a) Access version & bitness b) Whether Office 365 is installed c) Windows version & bitness (32/64-bit)

Several functions are available for obtaining the Access version in varying degrees of detail.

GetAccessVersion e.g. 16.0 (for Access 2016/2019/2021/365)

GetAccessBuildVersion e.g. 16.0.14701 (for Access 365)

GetAccessEXEVersion e.g. Access 365 - Build 16.0.14701.20226

These are combined with another function IsOfficex64 which returns the value 32-bit or 64-bit

The full Windows version is obtained using a GetWindowsVersion function which returns e.g. Windows 10 Pro Version 21H2 - Build 10.0.19044.1348 64-bit

Too much code to post here.