Determine the user's version of Office / Office 365

Add-in Express™ Support Service
That's what is more important than anything else

Determine the user's version of Office / Office 365
Determine the user's version of Office / Office 365 
DevTools Corptax




Posts: 25
 Joined: 2012-12-02
I am trying to save some user environment information and I am running into trouble finding a way to obtain Office 365 specific information. How can I programmatically get the Subscription and Excel Version (full version) as displayed in About Excel?

I would like to be able to find 4 pieces of information, really:


  • How to simply detect whether it is Office 365 vs desktop version of Office

  • Human readable Version Name of the office product
    (e.g. Microsoft Office 365 ProPlus vs Microsoft Office Professional Plus 2016)

  • Human readable Version Identifier as displayed in 'About Excel'
    (e.g. Microsoft Excel 2016 MSO (16.0.9126.2259) 64-bit)

  • Office 365 Version and Channel
    (e.g. Version 1803 Semi-annual Channel)


Thanks for any help...
Posted 12 Sep, 2018 13:41:54 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello,

There are no ways to get this info using the object model of the host application.

DevTools Corptax writes:
Human readable Version Identifier as displayed in 'About Excel' (e.g. Microsoft Excel 2016 MSO (16.0.9126.2259) 64-bit)


I suppose you can retrieve the version part of that string from the file version of the EXCEL.EXE process in which your add-in runs. Also, use Envoronment.Is64BitProcess to find out the process' bitness.


Andrei Smolin
Add-in Express Team Leader
Posted 13 Sep, 2018 05:57:02 Top
DevTools Corptax




Posts: 25
 Joined: 2012-12-02
Thank you for the response, Andrei! I am going to look into seeing what I can pull out of the process and Environment.

I realize that this is a bit out of scope of your product support, but since your Dev staff work so closely with Office products including installation, do you happen to know of any registry keys or other ways to get definitive information about Office versions? I know our install checks certain registry keys (or the existence of them) just to see if Excel is installed at all... but those that we check just give us very general info.

Thanks for any additional help you are able to provide...
Posted 13 Sep, 2018 11:47:19 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello,

We never needed that info and we don't know what registry keys might contain it.


Andrei Smolin
Add-in Express Team Leader
Posted 14 Sep, 2018 02:43:22 Top