FSO Object used in VBA code?

[Homi]

Since we need to explicitly allow excel to use ms scripting runtime dll before we can use FSO, does this mean the code cannot be used by anyone else?
thanks

[Logit]

.
Not quite certain what your mean in your question. Let me say two things :


Excel is not very secure. By design it is almost impossible to protect VBA code from being accessed / used by others.

Because of the lack of security, anyone can access your code and do anything with it.


Do these comments answer your question ?

[gmayor]

If you use late binding to the Scripting.FileSystemObject e.g.

Dim FSO As Object
    Set FSO = CreateObject("Scripting.FileSystemObject")

the code can be used by anyone using Excel in Windows without specifically setting a reference to it as the appropriate DLL will be almost certainly be available.

[Homi]

Thank you for your response, I was curious because it would not run (gave error) if I did not set the reference. I will try on other machines and see now.
Regards