VBA - detect if user is running on 365

50 views Asked by At

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()
0

There are 0 answers