Mastering Excel Macros: FileSystemObject (Book 8)

This macro lesson continues with the topic of automation. Here you are going to learn how to use the FileSystemObject (FSO) object. The FSO object is the object that Windows uses to create, delete, copy files and folders. You will learn how to use the FSO to list all the subfolders in a folder, the files in a folder, create text files, etc. There are many additional actions you can do with FSO, at the end of the lesson there is a list of some popular FSO methods.

This lesson comes with a follow along workbook that has all the completed exercises.