Advanced VBA - Files and Folder Management

Name: Advanced VBA - Files and Folder Management
Rating: 4.4 (72 reviews)

File System Objects using VBA Macros

Last updated 9/2020

English

English [Auto],

What you'll learn

Learn how to use File System Objects in VBA Macros
Easy way to get details of Drives, Folders, Files
Create, Open Text Files and Overwrite, Read and Append content to the text files.
Learn how to get the List of Files and Folders and the Files and Folders exists or not
Learn Complete details about how to work on Files and Folders using Advanced VBA Macros.
Though it is advanced, the course is made to understand anyone in simple and easy manner.

1 section • 6 lectures • 1h 38m total length

Introduction to File System Objects4:15
Introduction - FILE SYSTEM OBJECTS
- Work with Folders & Files connected with the system
- Present inside the Microsoft Scripting Runtime Library
USES
- Create, Open, Read, Write & Delete Text Files
- Create, Alter & Delete Folders
- Iterate Files & Folders to the list
- Copy & Move Files or Folders
- Check if File or Folder exists or not.
CREATING FILE SYSTEM OBJECT6:58
CREATING FILE SYSTEM OBJECT
EARLY BINDING
Using By Reference Method
LATE BINDING
Using CreateObject Method
WORKING ON DRIVES13:32
WORKING ON DRIVES
Functions are used to work on Drives
WORKING ON FOLDERS32:32
WORKING ON FOLDERS
Functions are used to work on FOLDERS
WORKING ON FILES23:45
WORKING ON FILES
Functions are used to work on FILES
WORKING ON TEXT FILES17:05
WORKING ON TEXT FILES
Functions are used to work on Text Files

This video explains complete details

> What are File System Objects

> How to use File System Objects

> Get Information on Drives, Folders, Files

> Create, Copy, Move, Delete Folders and Files

> Create, Open Text Files

> Get all the File Names, Folder Names, Sub-Folder Names

> Check if the Folder, Files exists or not