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

5 views (last 30 days)
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?

Answers (2)

Tejas M U
Tejas M U on 2 Jul 2014
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 on 13 Sep 2016
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.

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!