VBA project error and MATLAB path?

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

Answer 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