如何在Office(Excel)2007版本中运行Excel(Office)2002自动化 [英] How to Run a Excel(Office) 2002 Automation in Office(Excel) 2007 version

问题描述

我在Windows XP SP2 OS和MS Office 2002中为我的Excel Automation开发了一个程序.

完成项目后，质量检查团队在Windows 7 OS和MS Office 2007 for Excel电子表格中测试了我的项目.

但是，在进行测试之前，他们编译了我的项目.在编译时，程序弹出有关Excel不兼容的错误.

我下载了Oxppia(用于在Excel 2002中完成的excel自动化)，并将其安装在装有Windows 7 OS的测试计算机中.

我收到错误消息，缺少文件，无法继续安装.


这些人可以为我提供下载我可以安装在测试PC中的oxppia的链接吗?
并请帮助我.


谢谢.

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.

推荐答案

首先， ^ ]，您有一篇有趣的文章...

First of all, here[^] you got an interesting article...

全局程序集缓存中的主要互操作程序集

要执行某些开发任务，必须在开发计算机的全局程序集缓存中安装PIA并将其注册. 通常，在Office上安装Office时会自动安装PIA.开发计算机.有关更多信息...

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...

全局程序集缓存中的主要互操作程序集

Visual Studio中的每个Office项目模板都旨在与单个Microsoft Office应用程序一起使用.若要在多个Microsoft Office应用程序中使用功能，或在Visual Studio中没有项目的应用程序或组件中使用功能，则必须添加对所需PIA的引用.

在大多数情况下，应该在Visual Studio的%ProgramFiles%\Microsoft Visual Studio 10.0\Visual Studio Tools for Office\PIA\目录下添加对PIA的引用.这些版本的程序集显示在添加引用"对话框的.NET选项卡上.有关更多信息，请参见如何:通过主互操作程序集定位Office应用程序.

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.

还有另一种 [ Office XP PIA [ Office 2003 PIA's [ ^ ]
Office 2007 PIA [ Office 2010 PIA's [

And another one[^].

List of PIA''as...
Office XP PIA''s[^]
Office 2003 PIA''s[^]
Office 2007 PIA''s[^]
Office 2010 PIA''s[^]

这篇关于如何在Office(Excel)2007版本中运行Excel(Office)2002自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！