Access/Windows/Office 365 Version Checker

[isladogs]

When clients report issues or forum members ask questions, we often need to ask which version of Access/Windows/Office they are using.
Unfortunately, MS doesn't provide all the info in an accessible form that can be exported to a text file or similar.

I have created a utility that gets all the important info and displays it on a form:



The info can be exported to a text file



It can then be emailed by clients to me as the developer.
It could also be useful for forum members to upload this info with their questions.

The utility is available as a FREE Access add-in in ACCDE format from my website: https://www.isladogs.co.uk/avc-addin/index.html


Both 32-bit & 64-bit versions are provided. It works in all versions from 2010 onwards
Full installation instructions for using as an add-in are provided though it can also be used as a standalone app.

I hope it is useful to others

[orange]

Thanks Colin,
Works fine.


Access / Windows/ Office Version Info
=====================================

Date/Time: 02-Sep-22 7:26:08 AM
Workstation Name: LAPTOP-DELL2IN1
Windows Build: 10.0.19044.1889
Operating System: Windows 10 Home Version 21H2 - Build 10.0.19044.1889 64-bit
Access Build: 16.0.15427.20210
Access Full Version: Access 365 Version 2207 - Build 16.0.15427.20210 64-bit
Access Path: C:\Program Files\Microsoft Office\root\Office16\
Office 365 Installed: Yes
Office Install Method: Click-to-Run
Update Channel: Current Channel
Update Option: ENABLED: Updates are automatically downloaded and installed

[ranman256]

Public Function getOffVer()
Dim vRet
Select Case Int(Application.Version)
   Case 16
     vRet = "2016/2019/off365"
   Case 15
     vRet = "2013"
   Case 14
     vRet = "2010"
   Case 12
      vRet = "2007"
   Case Else
      vRet = "older than 2006"
End Select
getOffVer = vRet  & " ver#:"  & Int(Application.Version)
End Function

[isladogs]

That's fine if all you need is the Office version. BTW you forgot Office 2021.
However these days with the almost inevitable bugs associated with each month's Office updates, more precise info is required.

All the info is obtained using VBA including multiple registry calls.
However, the Office monthly version number e.g. 2207 can only be found online. So an internet connection is needed for that item

[isladogs]

Following feedback from users, I’ve now added the following:

1. Copy to Clipboard feature - to make it even easier to paste the info into an email or forum post
2. VBA References list - any missing references are marked as *BROKEN*

I’ve also tidied up the code partly to help the form load faster
The latest version is 2.67.
For more information and to download the add-in, see my web article: https://www.isladogs.co.uk/avc-addin/

As before the add-in is FREE and is available as 32-bit/64-bit ACCDE files for use with Access 2010 onwards












A video is now available on YouTube: https://youtu.be/euad5S-wOig