32-bit dll in Office 64 bit

Question

I understand that I cannot load a 32-bit dll in a 64-bit process. I have a 32-bit dll (VB6 component), without source code, which is loaded into the Excel Automation Macro. What are my options?

Answer 1

32-bit add-ins are not supported on the 64-bit version. Microsoft recommends using the 32-bit version of Office if you are not using the 32-bit process memory limits that might occur if you need to deal with extremely large spreadsheets:

Office 2010 :

• Office, ActiveX, , , Office, 32- , Office, 32- Office 2010 ( ) , 32- 64- Windows.

• Excel, Excel 2 (), 64- Office 2010. , 64- Office 2010, 64- Office 2010.

64- - , :

• , 64- ,

• ,

• .

, Microsoft: 32- COM- , - 64- 32- COM COM+. :

32- DLL 64-