Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

Note: What is Interop and PIA in Microsoft Office
 
Log Record Note: Which files contain the interface code from VSTO Apps to Office applications
 
The problem:
VSTO applications show the error: HRESULT 0x80028018 InteropServices.COMException
 
Reason:
Office applications such as Excel and Word are in a different language to the VSTO.
Visual Studio always accesses MS-Excel in English en-US. The references Microsoft.Office.Interop.Excel and Microsoft.Office.Interop.Word are used.
* VSTO = Visual Studio Developer For Office
 
The directory PIA runs for
https://msdn.microsoft.com/de-de/library/office/bb646840.aspx
* PIA = Primary Interop Assembly (PIA)

 
Manual installation of the PIA
Can I install Interop PIA files manually?
https://msdn.microsoft.com/de-de/library/office/kh3965hw.aspx
Install the primary Interop assemblies (PIAs) for Microsoft Office when you install Office.
To install the PIAs when you install Office

 
Description: What is PIA, Office PIA
To use the functions of a Microsoft Office application in an Office project, you must use the primary Interop assembly (PIA) for that application.
The PIA allows managed code to interact with the COM-based object model of a Microsoft Office application.
 
https://msdn.microsoft.com/de-de/library/office/15s06t57.aspx

 
 
List of all PIA Inteop files for MS Office
https://msdn.microsoft.com/de-de/library/office/15s06t57.aspx#pialist

Office-Anwendung oder Office-Komponente

Name der primären Interop-Assembly

Microsoft Access 14.0-Objektbibliothek
Microsoft Access 15,0-Objektbibliothek

Microsoft.Office.Interop.Access.dll

Objektbibliothek des Microsoft Office 14.0 Access-Datenbankmoduls
Objektbibliothek des Microsoft Office 15,0 Access-Datenbankmoduls

Microsoft.Office.Interop.Access.Dao.dll

Microsoft Excel 14.0-Objektbibliothek
Microsoft Excel 15,0-Objektbibliothek

Microsoft.Office.Interop.Excel.dll

 

 
 
 
PIA Interop files
A) under Visual Studio
 
For Visual Studio applications such as VSTO, the PIA files are copied to a subdirectory of Visual Studio.
 
Path for 64bit: \ Microsoft Visual Studio 12.0 \ Visual Studio Tools for Office \ PIA \ Office15
 
Path to the PIA files in Windows 10, Office x86 (32 bit)
C: \ Program Files (x86) \ Microsoft Visual Studio 14.0 \ Visual Studio Tools for Office \ x86
 
Interop files
To Excel: PIA (Interop.Excel) here in Office 32 bit x68
VSTOExcelAdaptor.dll
Mobile
»
Excel Addin: Creating a Ribbonbar Buttons for a vba Excel Addin
»
Remove custom toolbars
»
Simple list of all Ribbonbar icons with OfficeIconID
»
Office Icons: List of icons for the Ribbonbar
»
Excel Addin: create a Ribbonbar via VSTO Addin
»
Note: Installing the English Office Developer Tools for Visual Studio VSTO
»
Note: What is Interop and PIA in Microsoft Office
»
Excel VSTO Addin: Error HRESULT 0x80028018 InteropServices.COMException: Old format or invalid type library

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de