0

FileSystemObject in VBA

FileSystemObject, also referred as FSO, is an object that is made for accessing the computer files. It is located in MS Script Runtime Library tools in DLL system that allows the users to manipulate the files particularly the ones in the text format as per user’s preferences. You can view, read, alter, and can delete files of your computer by using this tool.

You can also iterate, copy, or relocate folders in a drive in your computer.

FSO makes adjustments in most of the files or folders circuitously. Its direct paths deal with only the drives in your computer system. This is true because the files and folders are contained in the drives, which makes its indirect path to the files and folders present in the drive.Review VLOOKUP Function for VBA.

FileSystemObject in VBA

How to Set Location to VB Script Runtime Library

You can establish a location to VB Script Runtime Library from MS Excel: you can use this path file WindowsSystem32scrrun.dll for it. Here are a few steps that you should follow to create this path:

Step1:

Open VB Editor. You can use a simple shortcut of “ALT-F11” to load the VB Editor.

Step2:

Go to Tools and to the References in the menu options.

Step3:

You will find a Listbox that will be displayed in the VB form.

Step4:

Select the check-box adjacent to the option of ‘Microsoft Scripting Runtime’ and click ‘OK’.

You have successfully set the location path.

How to Establish an FSO?

It is very simple to create an FSO path tool. You can follow the below steps create it:

Step 1:

Open VBA and go to VBA editor.

Step 2:

Select “Insert” and then, click “Module”.

Write “New FileSystemObject”.

It will create the FSO path tool.

 

Exceltimes

Leave a Reply

Your email address will not be published. Required fields are marked *