Hi,
Recently my computer got formatted.After that all my Macros which involved creating a reference to "Scripting.FileSystemObject" doesnt work.Its throwing an error "ActiveX cannot create the reference".
Can anybody help me on this?
I have the same references that i have before.
Thanks and Regards,
Krrishna
Last edited by gopi09_m; 05-09-2008 at 09:58 PM.
Run this command from the windows runbox:
If you don't get a message say "succeeded" then your dll may be missing or corrupt. If it says "suceeded" try your code again.regsvr32 scrrun.dll
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Sounds definitely like you don't have the dll. If this was done by an IT department, have a word and see if they now have a policy on scripting, many don't allow it.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
