Problem Deploying Excel Add-in using Builder EX: missing DLL files.

Question

Richard de Garis 2011-2-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/985-problem-deploying-excel-add-in-using-builder-ex-missing-dll-files

I'm very new to using the Builder EX toolbox and I'm finding the deployment not to be as straightforward as the User Guide suggests.

I can build, package and deploy on my own MATLAB PC, no problem. When I deploy to another non-MATLAB PC, I include the MCR installer and everything works fine until I get the following error:

"Source: VBA Project Message: Automation error. The specified module could not be found."

The troubleshooting notes talk about path settings, but that's not it. I found, using www.dependencywalker.com that the following DLL files were missing:

MSVCP100.DLL MSVCR100.DLL DWMAPI.DLL

Having specified the free version of MS visual C++ as the compiler for the Compiler toolbox, I found that installing the MS Visual C++ 2010 Redistributable Package (x86) vcredist_x86.exe seemed to solve the issue - although it appears it must be installed after the MCR installer, otherwise it doesn't work.

Okay, so to the question: Why is all this necessary; why are the DLLs missing in the first place; how can the vcredist file be packaged AND automatically executed AFTER the MCR? In fact, if all this is not in the documentation - that is to say I couldn't find it - is there not perhaps another way that avoids all this hassle? Your help and advice is very much appreciated!