32-bit compiled Excel Add-in in a 64-bit environment (Win 7 x64, Excel 2010 x64)

3 次查看（过去 30 天）
Bernd
Bernd 2014-7-2
回答： SOUY Bunheng 2016-9-13
Hi all,
I have compiled a 32-bit Excel Add-in and it worked fine in our previous environment (Windows XP x64, Excel 2007 32-bit)
It also works fine with Excel 2010 32-bit and Windows 7 x64, I just had to register the project DLL with the regsvr32 command, and I could use the Excel add-in on a computer that did not have Matlab installer (only the MCR library)
However, once we transitioned to Excel 2010 x64, the add-in did not work anymore.
I tried re-registering the DLL and it didn't work.
I got the error 429, "ActiveX component can't create object"
This is the same error I got with Excel 2010 32-bit, and it was fixed by registring "myproject.dll" with the "regsvr32" command.
However the fix did not work for Excel 2010 x64.
Does this mean I need to recompile the add-in using a 64-bit version of Matlab (and Matlab Compiler/Builder)?
Or is there an easy fix to this problem?

请先登录，再回答此问题。

回答（2 个）

Tejas M U
Tejas M U 2014-7-2
Since you have moved to 64 bit Excel, you will have to recompile the add-in on a 64bit MATLAB to link them with the right DLLs
SOUY Bunheng
SOUY Bunheng 2016-9-13
Hello, i have some problems with excel add in. I have compiled the m.file with matlab 2013a 32bit but when i cannot use the function wizard MATLAB Builder EX in excel 2010 32bit. When i click on function wizard MATLAB Builder EX in excel 2010 it said that: Automation error ClassFactory cannot supply requested class. Could you help me please? Thanks.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by