Advanced VBA - Files and Folder Management

File System Objects using VBA Macros
Rating: 4.8 out of 5 (20 ratings)
1,780 students
English
English [Auto]
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.

Requirements

  • Basic VBA Macros knowledge will be preferred

Description

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

Who this course is for:

  • VBA Developers, Macro Programmers, Analysts, Automation Specialist, Programmers

Course content

1 section6 lectures1h 38m total length
  • Introduction to File System Objects
    04:15
  • CREATING FILE SYSTEM OBJECT
    06:58
  • WORKING ON DRIVES
    13:32
  • WORKING ON FOLDERS
    32:32
  • WORKING ON FILES
    23:45
  • WORKING ON TEXT FILES
    17:05

Instructor

Analytics & Reporting Experts
iTech Analytic Solutions
  • 4.4 Instructor Rating
  • 63 Reviews
  • 4,141 Students
  • 4 Courses

"iTech Analytic Solutions (iTAS)” is a leading MIS Reporting, Business Analytics, Data Analytics & Data Science training institute contributing towards the requirement of current IT & NON-IT industries. iTAS offers training on Tools & Softwares like Advance Excel, VBA Macros, Power BI, Tableau, Python Programming, R Language, SQL, MS Access, SQL Server, MySQL, Advanced MS Word, Advanced MS PowerPoint.