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.
Ratings 3.91 / 5.00
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
Description
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.
Customization of file dialog buttons, titles to how to open multiple files with them to make more user friendly and robust program which can be run in any machine irrespective of the drives or folder paths they have.
Learn to manipulate text files using scripting library. We have everything discussed here from basic level to advance 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.
Assignment are added so that you can practice and check your score . Doubts will always be answered if asked.
Who Should Attend!
- Students who want to make career in analytics field. Require excel automation and want to learn how to pick files from folders and save them in other folders. Basically, from data compiling to accessing files and editing them from inside folders is what you will be able to learn here
