dll - Office 64 位中的 32 位 dll

Question

我知道我无法在 64 位进程中加载​​ 32 位 dll。我有一个 32 位 dll(VB6 组件)，没有源代码，它被加载到 Excel 自动化宏中。我有哪些选择？

Answer 1

32 位插件是 not supported在 64 位上。 Microsoft recommends使用 32 位版本的 Office，除非您遇到 32 位进程的内存限制，这仅在您需要处理超大电子表格时才可能发生:

The recommendations for which edition of Office 2010 to install are as follows:

• If users in your organization depend on existing extensions to Office, such as ActiveX controls, third-party add-ins, in-house solutions built on previous versions of Office, or 32-bit versions of programs that interface directly with Office, we recommend that you install 32-bit Office 2010 (the default installation) on computers that are running both 32-bit and 64-bit supported Windows operating systems.

• If some users in your organization are Excel expert users who work with Excel spreadsheets that are larger than 2 gigabytes (GB), they can install the 64-bit edition of Office 2010. In addition, if you have in-house solution developers, we recommend that those developers have access to the 64-bit edition of Office 2010 so that they can test and update your in-house solutions on the 64-bit edition of Office 2010.

如果由于内存限制而需要使用 64 位版本，您可以使用 the following options :

• If you have the source code, you can generate a 64-bit version yourself,

• You can contact the vendor for an updated version,

• You can search for an alternative solution.

Microsoft 在本文中实际上没有提到第四个选项:您可以创建一个 32 位进程外 COM 服务器，作为您的 64 位宏和旧的 32 位 COM 组件之间的代理，或者创建一个 COM+ 应用程序。此处提供了一个示例:

Accessing 32-bit DLLs from 64-bit code