VS 2005 vs Office XP PIA on a system with Office 2003/2007?

On my development system, I am running Office 2007 and Office 2003 was previously installed, and thus the Microsoft Office 11.0 and 12.0 object models were available. Our production environment is in the process of upgrading to Office 2007, but this has not happened yet - Office XP is still in production, and I need to be able to debug the (legacy) VB.Net application (VS 2005) that uses Office Interop against Office XP (10.0) (Excel).

Is it possible to simply download, install and reference the Office XP PIA ( http://www.microsoft.com/downloads/details.aspx?familyid=C41BD61E-3060-4F71-A6B4-01FEBA508E52 ) to compile the application launch? The previous version was tested against Office 2007 and seemed to work with the "old" interop / PIA.

I have an "old" Interop.Excel, etc., the only link that causes me a problem is the Microsoft Office 10.0 object model (which mentions the Microsoft Office 12.0 object model, but with an exclamation mark in my IDE).

I also found http://www.codeproject.com/KB/office/Compile2003VstoVista2007.aspx (for Office 2003 on the system since 2007), which suggests installing an older version of Office and then massaging the project files in a text editor. Although I do not mind using a text editor in project files, I would prefer not to install Office XP, unless I should (I have access to it if I do this). And I would rather be able to download the project as is (with the "old" link).

+4
source share

All Articles