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!

Answer 1

[Aurelien Queffurust]

One page gives the step-by-step process: Deploying a Standalone Application on a Network Drive

You could read that first installing MCR is required and then you need to run vcredist_x86.exe on for 32-bit clients

Answer 2

[Richard de Garis]

Thanks for your response. I've just spent a very frustrating day trying to get this to work, ultimately with no joy.

Question: does the PC need a reboot after the dos path is changed; is a reboot required after a mwregsvr command?

[fabien hubans]

Next time , think about calling TMW technical support, they would have helped you by phone and given the same answer ;)

Sometimes I've noticed that a reboot is required , my answer would be "just try !"... in the worst case you lose 5 minutes to reboot