Learn Excel VBA – Files and Folder handling – Series6

We are Learning to deal with every type of file and folders data – Using one of the important library in VBA called SCRIPTING which offers us amazing classes like FileSystemObject , Folder and Files etc .

Use of Filesystem object class, text stream class, folder and file classes are discussed in this series from basic to advance.

How to go inside a folder and pick the needed files and then do the things like compiling data from them or modifying the files or moving them or deleting them.

Learn how to use the file–dialogs so that user can choose any folder of his or her choice and work accordingly.

Not just folders or Excel files –we are also going to see what to do if we have to overwrite or append the data in text files. Yes, we can even control the text files using scripting library, Very useful especially when you are dealing with big data.

Skip the files while running loops which you do not want. Set the filters in the extensions using file dialogs. Learn all types of file dialogs like open dialog. save as dialog, folder dialog and also why and where we can use them.