I need a way to figure out if user is running office 365 using VBA. If I user Application.Version for Office365 and Office2016 they both reutrn 16.0
I also tried to read the following registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration\ProductReleaseIds
but get an empty value. I see the key in the registry editor, but for some reason it does not read it. from what I was reading it looks like when running Office 32bit on 64bit windows it doesn't work.
read the version values using Application.Version trying to read from
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration\ProductReleaseIds
using
CreateObject("WScript.Shell").RegRead()