
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.
Distinguish cscript.exe and wscript.exe, noting console versus GUI execution, and explore wscript as a core object model. Practice with wscript.echo, sleep, and quit to observe script behavior.
Learn how to manage VBScript arrays by dynamically increasing their length, understand fixed versus flexible arrays, and preserve existing data with the preserve keyword.
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.
Learn the five VBScript loop statements: do while, do until, for, for each, and while, and how to choose the appropriate one for real-time projects through practical comparisons and examples.
Master vbscript do loops, including do, do until, and do while, learn how to exit loops with exit do or script.quit, and see practical counting and messaging examples.
Learn how to use the VBScript for loop to iterate from start to end with a step, including increasing, decreasing, and applying it to array processing and totals.
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.
Master ByVal and ByRef in VBScript, comparing value preservation versus value modification, and showing how parentheses can switch a ByRef call to ByVal.
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.
Explore built-in date and time functions in VBScript: declare and assign dates, extract month, day, year, and month names, and add days or months to dates.
Learn to format numbers and dates in vb scripting using number and date time functions. Control decimals, grouping, leading zeros, and negative display with parentheses.
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.
Explore the file system object and its object model, then learn to use its properties and methods to manage drives, folders, and files in VBScript.
Understand the object model as a collection of classes and objects with properties, actions, and the object dot method syntax.
Identify where the file system object resides in the script runtime DLL SCR Rundle, in system32, and explore the dictionary object, file system object, and script encoder.
Explore the FSO object model and the FSA object model to manage files, folders, and drives using properties, methods, and events, with hands-on VBScript demonstrations.
Explore the drive object in vbscript: list drives, determine space and type, and read the file system, volume name, and serial number using common properties and methods.
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.
Explore drive type, file system type, and volume name using a file system object. Convert drive types to user-friendly descriptions with a select case and display results in message boxes.
Explore the properties and methods for managing folders. Learn to create, copy, and move folders, and retrieve folder information.
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 how to copy a folder with VBScript using the FileSystemObject's CopyFolder method, including source and destination paths and an optional overwrite flag, yielding an exact folder copy.
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.
Move files in VBScript using FSO and file objects with move methods, including temp folders. Set up paths, rename targets, and handle existence checks with if statements.
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.
Learn to read files in vbscript using fso and file objects, including line by line, character by character, and full contents with read all.
Learn to read a comma separated values file line by line using a text stream, split lines by comma, and assign fields to array elements for names and phone numbers.
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!!