
Here is what you will learn in this course:
Variables & Constants
Message Box
Accepting User Input
Arrays - Single Dimension & Two Dimensions
Operators
Error Handling
Data Types
Conditional Statements - IF & Select
Nested Conditional Statements
Loops -
Do...While
Do...Until
For
For Each
While...Wend
Procedures
ByVal & ByRef
FSO - File System Object
Working with Excel
WSH (Windows Scripting Host)
Here are our recommendations for this course:
Editors:
Notepad will work just fine. However, notepad++ or VSCode might be a better choice.
To the most part, the course lectures utilize VSCode.
Practice:
Nothing replaces hands-on coding.
Do not skip assignments & projects.
Learn VBScript array handling with LBound and UBound to get lower and upper indices, IsArray to test arrays, and Erase to clear arrays through practical examples.
Use the vbscript filter function to extract array items that contain the letter a, print matches, and demonstrate the inverse with not matched criteria.
Explore two dimensional arrays in vbscript, using column index and row index with zero based indexes; learn to declare, populate, and access a phonebook example with column and row concepts.
Explore vb scripting conditional statements, including if, else if, else, and nested if, plus select case, and learn to handle message box responses to drive different workflows.
Explore the select case construct to handle multiple conditions, including examples with 100, 300, 400, 500, and 600 values, default else, and real-world usage like payment processing and weekday-based branching.
Handle message box responses by checking the return value against vbYes, vbNo, and vbCancel. Use these constants to drive conditional workflows or actions based on user selection.
Explore the for each loop and its difference from a for loop, iterating a one-dimensional array and printing each item with wscript.echo to demonstrate the construct.
Here is what you will learn in this section:
Procedures
ByVal & ByRef
Explore VBScript procedures, including sub procedures and functions, learn how functions return values, see hands-on examples with simple scripts, input, and a temperature conversion using a function.
Demonstrates VBScript procedures and functions, showing how to call add, subtract, multiply, and divide, include external scripts, and use the file system object.
Explore built-in VBScript string functions, including mid for substrings, length, reverse, lowercase, uppercase, replace, left, right, and trim variants.
Explore built-in string functions in vb scripting, such as replace, string compare, and end string to locate positions within a string, with case-sensitive and text compare options.
Understand how VBScript built-in functions null and empty differentiate uninitialized variables from truly empty values, and learn to check is empty and is null in sample code.
Explore VBScript built-in checks such as is numeric, is date, is array, and is object, with examples using variables and a file system object.
Learn to explicitly declare variables and use the file system object in VBScript to create folders with the create folder method, specifying paths and names.
Create a file system object, enumerate drives with a for each loop, and use the drive letter and count properties to display drive letters.
Explore how to obtain a drive object using the file system object and retrieve available space, free space, and total size for the C drive, converting bytes to gigabytes.
Learn to create a folder with a file system object in VBScript, using the create folder method and a folder exists check, plus message box feedback for creation or existence.
Learn to delete a folder in VBScript using a file system object and the delete folder method; the video shows checking existence before deletion and handling not found errors.
Move a folder using the move folder method by specifying a source and destination location, demonstrated with a file system object.
Learn the basics of the file system object model for files, including creating, opening, reading, writing, and closing with file system and file objects, text streams, and file modes.
Demonstrate writing to files using fso and file objects, creating or opening text files, and using write, write line, and write blank line with modes for reading, writing, and appending.
2026 Update
Added a simple online vbscripting editor (Beta ver1)
VBScript is an Active Scripting language developed by Microsoft. VB scripting allows users to automate tasks in a Windows environment. The concepts from this course benefit regular users (wanting to experiment) and QTP/UFT professionals. VBSkills enables QA Engineers to move their efficiency to a NEXT LEVEL. QA Engineers, QTP/UFT engineers, System Administrators, and Network Administrators use VBScripting skills to automate simple to complex daily tasks.
We will start from the basics and walk you through a learning journey to master the skills.
The course begins with variables, arrays, operates, and error handling. After you learn these basic skills, we jump into the conditional statements and loops. We have included a module to help you master the built-in functions. These built-in functions come real handy as you don't have to code that functionality.
You will also learn to work with Files, Folders, Excel Documents, and MS SQL Server.
The projects at the end of the course help you to move to the next level by pushing you to most of the skills gained in this course.
There is no replacement for hands-on coding. You will learn to code like a professional developing reusable code.
The Sample Scripts included helps students to learn quickly and experiment by modifying them. The course is well organized with High-Quality Videos, and sample scripts!!