ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error: "The specified module could not be found" but DLL is in place! (https://www.excelbanter.com/excel-programming/415154-error-specified-module-could-not-found-but-dll-place.html)

Chrisso

Error: "The specified module could not be found" but DLL is in place!
 
Hi All

I have an Excel 2003 file with macros that includes a reference to the
Microsoft Scripting Runtime Library. This works fine on my computer.
However, on a collegues computer we get this error:

Automation Error
The specified module could not be found.

The debugger then points to this line of code:

Set fso = CreateObject("Scripting.FileSystemObject")

The ToolsReferences windows has the following "Location:" for the
Microsoft Scripting Runtime Library:
C:\WINDOWS\SYSTE32\scrrun.dll
which I *can* find on the system.

Does this mean that the registry is confused somehow? It knows where
the dll is but still produces the automation error.

What should my next step be? Re-install Excel? Or can I run a utility
to check the registry?

Thanks for any ideas,
Chrisso

Chrisso

Error: "The specified module could not be found" but DLL is inpla
 
Great - thanks Shasur.

That seems to have done the job.

Chrisso


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com