Learn Excel VBA - Files and Folder handling - Series6
Work with filedialogs/files/folders efficiently and learn the art to copy /cut/modify the data inside these files.
4.11 (14 reviews)
94
students
5 hours
content
Nov 2021
last update
$19.99
regular price
What you will learn
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 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 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 copy folders or move folders plus how to copy multiple files and move them under another folders
How to create Folders, Sub Folders - if they exists how to avoid re-creating them
Using FileDialogs take you 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 fie system object class
Screenshots
Related Topics
1648308
udemy ID
4/16/2018
course created date
2/8/2020
course indexed date
Bot
course submited by