VBA project error and MATLAB path?

1 次查看（过去 30 天）
Jared
Jared 2020-4-30
回答： 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

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

回答（1 个）

Kiran Felix Robert
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

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by