Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB9.0 VB.NET
I developed a program in a Windows XP SP2 OS and MS Office 2002 for my Excel Automation.
 
when project is done, QA team tested my project in a Windows 7 OS and MS Office 2007 for Excel spreadsheet.
 
But, before they did testing, they compiled my project. on compilation, program popped an error regarding Excel Incompatability.
 
i downloaded Oxppia(for my excel automation that was done in excel 2002) and installed it in the test pc with windows 7 OS.
 
i received an error, missing file, cannot continue installation.
 

Is these someone who can provide me with a link to download oxppia that i can install in the test pc?
and please help me with.
 

Thank You.
Posted 10-Apr-12 21:04pm
Comments
losmac at 11-Apr-12 14:43pm
   
Did OXPPIA means: Office XP PIAs)? Do you really need this software, if you can replace OXPPIA functionality using .NET? Please, provide more informations...
Alan Tuscano at 15-Apr-12 20:45pm
   
Yes Its Office XP pia, I've browsed google for answers on what to use when running a lower version of office in windows 7 and answers always points to oxppia download.
 
I've developed the program in Windows XP xp2, using Office 2002 in my excel automation(Office 2002 is the version installed in this workstation i'm using).
 
I've tested the program in other pc's using Windows XP sp3 as OS and office 2003 and or Office 2007 and my program works well.
 
Only when the QA Team copied the whole program and compiles it in a Windows 7 OS with Office 2007 that i got error having compatibility issue with the program Office2002 version. So, i resulted in downloading OXPPia but when i tried to install it in the windows7 pc, got error "Unable to continue Installation. Missing files".. I tried 3 times downloading OXPPia but repeatedly got the same error trice.
losmac at 17-Apr-12 13:46pm
   
Win7 and Office 2007 on the QA Team computer are 32 or 64 bit version? Why QA Team need to compile it on them computer?
Alan Tuscano at 25-Apr-12 0:04am
   
64bit.
 
I have no idea why they'd still compile the project when its already build. At first, i was thinking that they review the codes that is why they ask for the project folder, but then, what they do is only to re compile the project and in win7 platform.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

First of all, here[^] you got an interesting article...
 
Primary Interop Assemblies in the Global Assembly Cache
To perform certain development tasks, the PIAs must be installed and registered in the global assembly cache on the development computer. Typically, the PIAs are installed automatically when you install Office on the development computer. For more information...

 
Primary Interop Assemblies in the Global Assembly Cache
Every Office project template in Visual Studio is designed to work with a single Microsoft Office application. To use features in multiple Microsoft Office applications, or to use features in an application or component that does not have a project in Visual Studio, you must add a reference to the required PIAs.
 
In most cases, you should add references to the PIAs that are installed by Visual Studio under the %ProgramFiles%\Microsoft Visual Studio 10.0\Visual Studio Tools for Office\PIA\ directory. These versions of the assemblies appear on the .NET tab of the Add Reference dialog box. For more information, see How to: Target Office Applications Through Primary Interop Assemblies.

 
And another one[^].
 
List of PIA'as...
Office XP PIA's[^]
Office 2003 PIA's[^]
Office 2007 PIA's[^]
Office 2010 PIA's[^]
  Permalink  
v2
Comments
VJ Reddy at 1-May-12 20:58pm
   
5!
losmac at 2-May-12 7:39am
   
Thank you ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 7,903
1 Sergey Alexandrovich Kryukov 7,142
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,820


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 1 May 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100