VBA project error and MATLAB path?

Question

Jared 2020-4-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/521972-vba-project-error-and-matlab-path

回答： Kiran Felix Robert 2021-2-5

Hi all I have an Excel add-in I created that I've been using for a long time that is now randomly generating the following error in Excel when using add-in formulas: "Error in VBA Project: The specified module could not be found."

I've read Mathwork's documentation related to this error but still don't understand what exactly I need to do related to the path and where. FWIW add-in was created using R2019b.

Appreciate any help,

JK

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Kiran Felix Robert 2021-2-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/521972-vba-project-error-and-matlab-path#answer_615277

Hi Jared,

This issue arises if the following DLL files are missing:

MSVCP100.DLL MSVCR100.DLL DWMAPI.DLL

Make sure that MATLAB Runtime is on the Windows path. Other Excel related errors can be found in the documentation: https://www.mathworks.com/help/compiler/excel/errors-and-solutions.html

Refer this answer to know more about adding MATLAB to the system path

https://in.mathworks.com/matlabcentral/answers/94933-how-do-i-edit-my-system-path-in-windows