Advanced VBA - Files and Folder Management in Kannada

Name: Advanced VBA - Files and Folder Management in Kannada
Rating: 4.4 (17 reviews)

File System Objects using VBA Macros in Kannada

Last updated 9/2020

English

What you'll learn

Entire Course is in Kannada and made it very easy to understand to Advanced VBA in Kannada
Learn how to use File System Objects in VBA Macros in Kannada
Create, Open Text Files and Overwrite, Read and Append content to the text files in Kannada
Learn how to get the List of Files and Folders and the Files and Folders exists or not in Kannada
Learn Complete details about how to work on Files and Folders using Advanced VBA Macros in Kannada
Though it is advanced course, the course is made in Kannada to make sure anyone taking this course will understand the topics in simple and easy manner

2 sections • 9 lectures • 1h 54m total length

Introduction to File System Objects4:24
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:34
CREATING FILE SYSTEM OBJECT
EARLY BINDING
Using By Reference Method
LATE BINDING
Using CreateObject Method
WORKING ON DRIVES16:52
WORKING ON DRIVES
Functions are used to work on Drives
WORKING ON FOLDERS29:40
WORKING ON FOLDERS
Functions are used to work on FOLDERS
WORKING ON FILES20:01
WORKING ON FILES
Functions are used to work on FILES
WORKING ON TEXT FILES13:37
WORKING ON TEXT FILES
Functions are used to work on Text Files

07 FSO - CHECK DRIVE SPACE7:25
CHECK DRIVE SPACE
This Lecture explains how to find the free space available in the Drive specified
08 FSO - CHECK FOLDER EXIST7:27
CHECK FOLDER EXIST
This Lecture explains if the mentioned folder exists or not.
If the folder doesn't exists, a new folder will be created.
09 FSO - GET FILE NAME, SIZE, DATE8:19
GET FILE NAME, SIZE, DATE
This Lecture explains how to get the list of files in the folder and get file name, size of the file, the last accessed details from the file mentioned

This video are in Kannada and 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