Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I try to run the QDE Toolkit’s Excel macro “tk_RVisMedian_AddToWorksheet”, I (sometimes) get an Error 53. What should I do?

Error Excel macro qde run Toolkit Try
0
Posted

When I try to run the QDE Toolkit’s Excel macro “tk_RVisMedian_AddToWorksheet”, I (sometimes) get an Error 53. What should I do?

0

2002-05-05 There are two types of DLLs that must be found by Excel’s Visual Basic for Applications (VBA). The FORTRAN subroutines are in the Dynamic Linked Library (DLL) MCMedian that you can explicitly tell VBA about (see qestion immediately below), and it in turn must find the run-time DLLs. The search path will normally include the current directory, so if the DLLs are there, all should be well… unless some other program still has control of the “current” directory and has not yet given up control. (We’re not Windows experts, but this seems to be what is happening.) In any case, the solution is to register the necessary run-time DLLs with Windows so that they can always be found. However, at least one copy of one DLL (the Microsoft Visual C run-time DLL) is almost always open – which is why we recommend considering Compaq’s Visual Fortran run-time installer (fully redistributable) VFRUN66AI.exe to fix this problem.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123