Common Issues

With great power comes great responsibility!

Excel Lab relies on a combination of complex technologies to provide you access to powerful calculators and analytics. The following are common installation issues that may occur and how you can solve them.

Error in VBAProject: ActiveX component can't create object

The required libraries (DLLs) were not successfully registered with the system during the installation process.

Solution

Follow the steps outlined for registering the library files.

Step 2: Register Libraries

Error in VBAProject: Automation errorClassFactory cannot supply requested class

The required libraries (DLLs) were not successfully registered with the system during the installation process.

Solution

Follow the steps outlined for registering the library files.

Step 2: Register Libraries

Error in VBAProject: the specified module could not be found

The environment path to the prerequisite component runtime is either incorrect or not initialized correctly. Typically, this can occur when trying to use Excel Lab immediately after installing the prerequisite runtime.

Solution

Reboot your machine. If the problem continues to persist, verify that your system path includes C:\Program Files\MATLAB\MATLAB Runtime\v99\runtime\win64

(1) Open the Windows command console and list your system path variable

echo %PATH:;=&echo.%

(2) Verify that C:\Program Files\MATLAB\MATLAB Runtime\v99\runtime\win64 is included in the list

(3) Reboot your machine.

(LoadLibrary)Error: 0x0000007e Message: The specified module could no be found.

This error message appears when you are trying to run the registration batch file (_install.bat) from a different folder of its location.

Solution

Change your working folder in the command console to the location of _install.bat; only then run the batch file. Or you can use the following multi-command syntax in a single line

cd "C:\Program Files\Windham Labs\WindhamXlsLab\application\" & _install.bat

File Already Exist

When adding the add-in in Microsoft Excel, if prompted to replace the file location, select NO.

Access Denied Registering DLL

Access denied appears in the command console when following Step 2: Register Libraries for setting up Excel Lab.

Access denied while registering the DLL library.

Solution

The setup step requires elevated administrative privileges when following the instructions. Please work with your IT professional to start the command console with administrative privileges to execute the installation steps.