pia

Trying to do Office Automation with Excel 2007, but keeps using Excel 2003

Environment: Windows XP machine Both Excel 2007 and Excel 2003 installed (in that order, not chronologically). C# 3.5 Problem: When I use the PIAs to do some Office automation, I use the following line of code: var excel = new ApplicationClass(); The PIA's version specifically refers to it as Excel 12. C:\WINDOWS\assembly\GAC\Micro...

Excel problem with deleting CustomProperty in Korean

On a Korean OS I'm getting the following exception when trying to call the Delete() method on the CustomProperty object. I'm doing this in C# using the Office2003 PIA for Excel. This HRESULT isn't that helpful to me, can anyone help figure out what's going on here? "Exception from HRESULT: 0x800A03EC"} System.Exception {System.Runti...

Automating Excel through the PIA makes VBA go squiffy.

I have absolutely no idea how to start diagnosing this, and just wondered if anyone had any suggestions. I'm generating an Excel spreadsheet by calling some Macros from a C# application, and during the generation process it somehow breaks. I've got a VBA class containing all of my logging/error-handling logic, which I instantiate using a...

tlbimp.exe error: Referenced type library 'stdole' does not have a primary interop assembly registered

when I try to import PIA by tlbimp.exe, get the following error: TlbImp : error TI0000 : System.ApplicationException - Referenced type library 'stdole' does not have a primary interop assembly registered. My command is : "C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin\tlbimp.exe" "C:..\craxdrt9.dll" /primary /keyfile:"C:..\keyfile....

Output excel spreadsheets with or without Office PIA

I have a program that currently outputs Excel via SpreadsheetML files. I build these using streams. This is very space inefficient for Excel; the files can be 5 to 6 times as large as other Excel binary formats. I would like to output a binary excel format such as .xls or .xlsx, but I don't want to have the installation of the program...

Word Interop compile time error

I am getting the following error when referencing the assembly Microsoft.Office.Interop.Word in my asp.net application. The type 'Microsoft.Office.Interop.Word.ApplicationClass' exists in both 'C:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Word\11.0.0.0_71e9bce111e9429c\Microsoft.Office.Interop.Word.dll' and 'C:\WINDOWS\assembly\GAC...

Why attachment size given by Outlook programming interface is always wrong?

Hi, Trying to use Outlook Interop in C#, I noticed a curious thing. First I get the size of an attachment with Attachment.Size property. Second, I save the attachment to a file using Attachment.SaveAsFile method. Comparing the real size of a saved file and a size given by Outlook, I notice that the real, saved file is always smaller...

Where can I find MS ActiveX Data Object (ADOR) Primary Interop Assembly (PIA)?

I'm trying to generate a Primary Interop Assembly for one of my projects that references Microsoft ActiveX Data Objects (MDAC 2.8). Adding this library through the References dialog box in Visual Studio adds the Interop.ADOR.dll file to the bin directory of the solution. However, when I run tlbimp.exe I get the error: C:\Solution> tlbi...