I have not done any programming for quite some time, so apologies if this is simple. I have had a look on several forums but haven't found quite what I am looking for.
I have Microsoft Office 365 ProPlus with Excel Version 1902. The Office version was pushed centrally form IT; a click to run type deployment so I didn't have options to ensure PIAs were enabled.
I am using C# in Visual Studio Community 2017.
I am wanting to include the Microsoft.Office.Interop.Excel reference to allow me to do certain operations in Excel from within my application.
When I attempt to Add the reference to my project, under assemblies there are non of the PIAs available.
However when I look under the COM options there is the "Microsoft Excel 16.0 Object Library" available.
How do I install or enable the PIAs so that I can use these with Office 365?