.NET Add-In and XP vs 2003 PIAs

[Matthew Wieder]

We developed an Excel Add-In using C# and the Office XP PIAs. We distribute
the XP PIAs with our application. We recently installed it at a client site
who is running Office 2003 (winXP) and they started receiving Excel
automation exceptions when forms from our Add-In were displayed. If we go
into the .NET configuration and remap requests for the version 10 (XP) PIA to
route to version 11 (2003) and reboot, then the exceptions disappear.
I have come accross conflicting documentation as to whether v10 PIAs can be
used against Office 11. If they can not, what is the suggested
build/deployment strategy for applications that need to run on both versions
of Office?

 

[Andrei Smolin [Add-in Express]]

Hello Matthew,

Some of Add-in Express customers run into this problem, too. I suppose that
you acquire a new Excel.Application object (via New or CreateObject or such)
when your forms are loaded. Try to use the Excel.Application object supplied
in the StartupComplete event of your add-in.

If this is not the case, please show me the code that works when your
form(s) is loaded, activated, and resized. You can use my e-mail to send me
this code.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader