MATLAB Answers

Bernd
0

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

Asked by Bernd
on 2 Jul 2014
Latest activity Answered by SOUY Bunheng on 13 Sep 2016
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?

  0 Comments

Sign in to comment.

2 Answers

Answer by 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

  0 Comments

Sign in to comment.


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

  0 Comments

Sign in to comment.