MATLAB Answers

VBA project error and MATLAB path?

2 views (last 30 days)
Jared
Jared on 30 Apr 2020
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

Answers (1)

Kiran Felix Robert
Kiran Felix Robert on 5 Feb 2021
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

Community Treasure Hunt

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

Start Hunting!