Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Excel Vba Basic To Super Advance Part2

    Posted By: ELK1nG
    Excel Vba Basic To Super Advance Part2

    Excel Vba Basic To Super Advance Part2
    Published 7/2022
    MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
    Language: English | Size: 5.22 GB | Duration: 11h 6m

    In-depth study of how to deal with 100s of files insider folders, text file data handling and SuperPowerful USERFORMS

    What you'll learn
    In this VBA Part2 ,We are focusing on three topics and 3 sections for you - File & Folder Handling ,USERFORMS,Error handlers with message /input boxes
    It has two sections and knowledge of arrays, loops, if statments is must. You can check VBA Part1, if you want to learn all this.
    You shall learn how to create files or folders , text files
    Taking a deep dive into library called Scripting and learning the classes of this library like fiesystemobject, file, folder and text stream
    You shall be able to pick data from hundreds of excel or text files and will be able to collate it under one roof and then do whatever is required.
    Creating workbooks, text files, folders, jumping inside subfolders, putting conditions, modifying the data , whatever is required, you shall be able to do it.
    You shall be able to learn how to create VBA Dashboards using UserForms. Its fully basic to advance course
    You shall be able to understand why it is important to know error handlers like On Error Resume Next and Go to Err.
    Also, how to create message and input box with real time examples
    Requirements
    VBA Knowledge is required since this is our Part2. Knowlege of variables, arrays, loops ,functions is required. One can watch VBA Part1 , if haven't before opting for this part2.
    If you already know above topics then please go ahead and take admission in this course.
    Description
    In section1, We are Learning to deal with small or large data stored in excel workbooks or text files using a library called SCRIPTING which offers us amazing classes like FileSystemObject , Folder and Files and Textstream.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.In section2, we have covered all form controls like labels, textboxes, combo, listbox, frame, option buttons, check boxes and many more.From understanding the Userform control design and properties, you shall also see the magic of userform events which are very much required to create projects.All of your doubts will be answered via email or forum in 24 hours.in section3, you shall learn Error handlers like On error resume next and goto err. You shall see what are the scenarios when we already know we can have errors - VBA Errors so if we want to ignore those errors and keep continuing running the vba code, how to do that and first of all, why in first place , I will like to ignore the errors.We will then learn how to use and customize a message box and input box in vba with various examples.

    Overview

    Section 1: Introduction to Scripting Library to work with Files, folders and text files

    Lecture 1 Introduction to Library called Scripting

    Lecture 2 How to Import file information in excel from any folder

    Lecture 3 How to combine data from different workbooks - Amazing, impactful

    Lecture 4 How to copy or move folders and files

    Lecture 5 Create a folder of your desire

    Lecture 6 What are file dialogs and Role

    Lecture 7 Use Vlookup - FileDialogs are so powerful

    Lecture 8 Open file dialog introduction - Use to open excel files

    Lecture 9 SaveAs file dialog now

    Lecture 0 Get subfolder names from any folder

    Lecture 10 Let us start with text files - take your levels to new heights

    Lecture 11 Open and Read text files data

    Lecture 12 Import text files in excel

    Lecture 13 Write data in text files - be a All Rounder

    Section 2: VBA UserForms for Dashboards

    Lecture 14 What are the UserForms - Create and understand them

    Lecture 15 Know combo box, option buttons,frames, text box etc

    Lecture 16 Userform Events - Why you need them and how to use these events

    Lecture 0 How to do coding - Insert your data in excel from form controls

    Lecture 0 Learn Change event, after update, Queryclose and more - Super duper fun

    Lecture 0 Our ListBox in forms- its significant and its huge learning

    Lecture 0 How to get what is selected in a List Box

    Lecture 0 Show files in a Listbox if a folder changes in combo box - Another level

    Lecture 0 Project for you - More live case study means more confidence

    Lecture 0 How to move up and down the listbox items - Super knowledge project

    Lecture 0 Advance Level Dashboard using USER FORM - Challenge your limits

    Lecture 0 Finishing the Dashboard - Final Touch

    Lecture 0 Error Handlers - Why we need them - Deep Dive

    Lecture 0 Project for you

    Lecture 0 Message box - intro

    Lecture 0 INPUT BOX Introduction

    Lecture 0 Application inputbox - set rules on data type

    Excel data analytics, Those who like to automate data work in excel.,Those who want to create dashboards by using userforms of VBA.