DLL Error in excel sheet

Hi. I am trying to follow this example in the page:

https://www.mathworks.com/help/compiler/excel/create-an-excel-application-from-matlab-code.html

I am getting this error message when I put the code in excel

Error in mymagic.mymagicClass.1_0: MWComUtil 9.11 could not be found in the registry. Please refer to MATLAB Compiler SDK documentation for instructions on how to install and register MWComUtil.

I couldn't find anything for its instructions.

Can anyone help figure this out?

[Walter Roberson]

https://www.mathworks.com/help/compiler_sdk/com/registering-and-referencing-the-utility-library.html

[Baha411]

This doesn't work, I had already tried it. See the error message I get:

C:\WINDOWS\system32>mwregsvr mwcomutil.dll

(LoadLibrary)Error: 0x0000007e Message: The specified module could not be found.

[Baha411]

Does anyone know where the this "mwcomutil.dll" file is?

[Walter Roberson]

https://itectec.com/matlab/matlab-how-to-register-dll-file-in-matlab-donet-builder/

[Baha411]

The link you sent works, but the link inside that page is dead. Any other idea on how to fix it?

[Baha411]

Can someone from mathworks reply to this, please? Do I need to install/reinstall something? This is something very simple yet not so like that for matlab I guess. This is very disappointing.

[Walter Roberson]

"Does anyone know where the this "mwcomutil.dll" file is?"

In R2018b it showed up as

C:\Program Files\MATLAB\R2018b\bin\win64\mwcomutil.dll
C:\Program FIles\MATLAB\MATLAB Compiler Runtime\v716\runtime\win64\mwcomutil.dll

I do not happen to have MATLAB Compiler for R2021b installed on Windows.

[Walter Roberson]

The important part of the link was the sentence,

"mwregsvr resides in the same folder as needed DLL's"

[Walter Roberson]

Can someone from mathworks reply to this, please?

MATLAB Answers is answered by volunteers.

My late night Sunday / Monday was spent upgrading my virtual MS Windows machine to catch up on the months of operating system updates since the last time I had reason to boot Windows, and after a poor sleep Monday morning, Monday afternoon and evening was spent catching up on sleep after some unexpected dental work.

If you need an answer from Mathworks itself, you should open a support case.

[Baha411]

Thanks for your answers Walter. I had opened a case, but they hadn't replied me at the time I was still asking the same question here. They finally send me pretty much the same info you sent and I was able to get rid of the issue.

Now I have another question about how to use these excel add-in s in other computers where there is no matlab or related software. I tried it other computers and addins don't work. What's the shortest way to get them working without needing to install matlab in other computers?

[Baha411]

@Walter Roberson

I have a few quick followup questions regarding addins for excel.

Here is an example:

function [x, y, z] = funct1(input1, input2, input3)
x = input1*input2;
y = input1+input2;
z.out1 = input1*input2^2;
z.out2 = input1*input3^2;
z.out3 = input2*input3^2;

So, the question is how I can extract which output to be printed in excel when I call this addin? For example, if I want only x to be printed in excel; or only y to be printed, or only z.out1, z.out2, or z.out3 to be printed, how can I specify that in excel? I really appreciate if you could answer this.

[Walter Roberson]

@Baha411

Sorry, I have no experience in that matter. I do not have Excel for Windows, and these features do not work on Excel for Mac.