Excel VBA Files & Folders Data Handling Course- Series5
How to work with FOLDERS and FILES inside them
Updated on Jun, 2025
Language - English
Office Productivity,Microsoft,Excel
Lectures -12
Resources -2
Duration -4.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Learn about Folders and Files - How to work with them dynamically- Must learn course for Data Analysts and VBA developers
How to handle Excel files lying inside a Folder or Folders
How to pull out the data from a folder which has 1000s Excel files. What if you need to copy the data from each of these files and compile it under one roof.
How to skip files with different extensions like.png or.doc, etc.
We are taking a deep dive into the Scripting library, which offers us powerful Classes like FileSystemObject, File class, and Folder Class
You will be able to handle large or small data coming from different files. You can use Vlookups in 100s of files with no difficulty after finishing this.
How to work with TEXT files. How to transfer txt file data into excel and vice versa as well.
How to modify the Text file columns data using the File System object class
How to use Collection Loops to loop through thousands of files inside folders and subfolders.
Use of File Dialogs like SaveAs, OpenFile, or OpenFolder
How to create Folders, and subfolders—if they exist, how to avoid re-creating them
Using FileDialogs takes your VBA to a new level where selecting a folder and files will be done dynamically.
Very practical Projects for you with clear explanation, including the office file dialog class with file system object class
Goals
- We are learning to deal with every type of file and folder data - Using one of the important libraries in VBA called SCRIPTING, which offers us amazing classes like FileSystemObject, Folder, Files, etc.
Use of Filesystem object class, text stream class, folder, and file classes are discussed in this series from basic to advanced.
How to go inside a folder and pick the needed files and then do 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 the 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 a scripting library, Very useful, especially when you are dealing with big data.
Skip the files while running loops, that 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.
Customization of file dialog buttons, and titles to how to open multiple files with them to make a more user-friendly and robust program that can be run on any machine irrespective of the drives or folder paths they have.
Learn to manipulate text files using a scripting library. We have everything discussed here from the basic level to the advanced level when it comes to file and folder manipulations.
Introducing the Collection Loops used to deal with text file data or hundred of folders or thousand of files.
Use if conditions and collection loops in the two amazing projects to show you the real use of libraries and loops.
Assignments are added so that you can practice and check your score. Doubts will always be answered if asked.
Prerequisites
- Knowledge of Basic Loops, Collection loops, IF Functions, and Variables is required. Any Excel version 2007 or above is ok.
Curriculum
Check out the detailed breakdown of what’s inside the course
Folder And Files Working
12 Lectures
-
What are we going to Cover - DEMO
-
Demo about course topics
08:28
08:28
-
Begin with the Course- Loop Excel Files under a FOLDER using Arrays , IF statements etc - Its very powerful
-
Files and Folder loops
01:37:48
01:37:48
-
Work with Text files
-
Text file
01:07:05
01:07:05
-
Project for you
-
Project
14:35
14:35
-
Introducing FILE DIALOGS for you
-
File Dialogs Introducing
01:06:23
01:06:23
-
File Dialogs and Subfolder collection Loops project
-
Project using file Dialogs
32:18
32:18
Instructor Details
ajay parmar
I have been teaching online from 13 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now