enable Microsoft Scripting Runtime library

I created an excel vba project that uses a number of scripting objects.  In trying to load into a corporate environment it errors at the point where it calls the object.  Can I write vba code that will enable this and/or is it likely to be prohibited by the security protocols of this corporation.  Macros run fine.
davidamAsked:
Who is Participating?
 
rspahitzCommented:
assuming that all the machines have the scrrun.dll accessible, you can try this to ensure that it loads:

sub ...
Dim fso As Object 'scripting.filesystemobject
Set fso = CreateObject("scripting.filesystemobject")
...
Set fso=Nothing
end sub
0
 
Michael FowlerSolutions ConsultantCommented:
It is possible that this library is either not on the corporate environment or not in the reference list.

You could try opening the macro in the corporate environment and checking the references. If it is not listed try looking for it in C:\Windows\System subfolder as Scrrun.dll

Michael
0
 
davidamAuthor Commented:
very complete answers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.