Explain about File system Object

     

  • File system object is an object is VBA, like WORKBOOK,WORKSHEET,RANGE

    •  

  • It is also having Methods

    •  

  • File system object works as a tool and enables the user to operate Files,folders,Drivers

    •  

  • User can create,delete,read,write,move,manipulate the files and folders with the help of file system object

    •  

     

  • With the help of Properties\Methods of FILE SYSTEM OBJECT: we can read,write,manipulate Text files in our computer data base\hard disk
  • We can loop through the files and folders

    •  

     

  • Drives:t explains about Drives in our system

    •  

  • Folders: It enable the user to create,delte,manipulate the foles in system

    •  

  • File: We can manipulate file with the help of this object

    •  

  • TextFile: we can manipulate text file

    •  

    Where we can find FILE SYSTEM OBJECT

     

     

  • Open VBE

    •  

  • Click on TOOLS - REFERENCES

    •  

     

  • Select MICROSOFT SCRIPTING RUNTIME

    •  

  • click on OK

    •  

  • Now MICROSOFT SCRIPTING RUNTIME Liabrary has been added

    •  

    Create File System Object Varaible

     

     

     

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli