Make Excel VBA file with FileSystemObject (FSO) "portable"

[PeteWright]

Hi there,

I am currently working on an Excel VBA code that uses the Microsoft Scripting Runtime or FileSystemObject (FSO), but I stopped coding for now, because I'm not sure if the File will work on other computers.

To be able to run my VBA code the user needs to press a button on the main sheet which then initiates a lot of other procedures like opening a text file and filling in a sheet with data.
If I am not wrong then:
For this to work (without throwing an error) the corresponding Reference (in this case the Microsoft Scripting Runtime) has to be loaded into the Excel file (via VBA Editor menu Tools > References).

My Excel file will only be used in our company by a few colleagues, so the worst case would be to enable the Runtime on all computers that will run the file.

What I am asking myself now:
How is the runtime implemented?

So my question now is:
What should I do that every user will be able to run my code?

Many thanks in advance.

 

[lrobbo314]

You can assign the variable using late binding so you don't need to add the reference.

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

 

[PeteWright]

You can assign the variable using late binding so you don't need to add the reference.

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

@lrobbo314 Nice, thanks. I'll try it tomorrow at work.

Is there anything else that needs to be done?