This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
VBScripting Fundamentals
Introduction to VBScripting
Introduction to VBScriptng (10:33)
Creating VB Scripts
Creating and Running VB Scripts (9:35)
Understanding MsgBox (8:49)
Demo Script(s)
Variables & Arrays
Variables & Constants (20:55)
Arrays (21:53)
Demo Script(s)
Accepting Input From Users
Using inputbox (17:48)
Demo Script(s)
Operators
Using Operators (3:21)
Demo Script(s)
Conditional Statements
Using IF Statement (20:05)
Using Select-Case Statement (8:47)
Demo Script(s)
Repeating Using Loops
Using do-while-until (21:11)
Using for Loop (14:25)
Demo Script(s)
Using Procedures
Procedures - Part 1 (7:09)
Procedures - Part 2 (7:36)
Procedures - Part 3 (11:03)
Procedures - Part 4 (6:42)
Procedures - Part 5 (8:20)
Demo Script(s)
ByVal and ByRef
ByVal and ByRef - Part 1 (10:06)
ByVal and ByRef - Part 2 (7:34)
Using Built-in Functions
Using Built-in Functions - Part 1 (10:30)
Using Built-in Functions - Part 2 (8:07)
Demo Scripts
FSO - Understanding FilesystemObject
Introduction (1:00)
What are File System Objects? (1:04)
What is Object Model? (8:21)
Where is FileSystemObject located? (1:51)
FSO Object Model (3:35)
FSO - Working with Drives
Drives Introduction (0:52)
Basic Script (2:54)
A Note About The Variable Names (0:58)
Drives Script 01 - DriveLetter and Count (3:51)
Drives Script 02 - Drive Space (2:34)
Drives Script 03 - Drive Types, FileSystem Type and Volume name (3:13)
Drives Script 04 - Serial Number and IsReady (1:53)
Drives Script 05 - DriveExists (2:24)
Demo Scripts
FSO - Working with Folders
Introduction (0:20)
Creating Folder (3:57)
Copying Folder (2:42)
Deleting Folder (2:41)
Moving Folder (2:12)
Getting Parent Folder Name (1:46)
Getting Folder Information (4:06)
Demo Scripts
FSO - Working with Files
Introduction (0:20)
Files Fundamentals (3:51)
Creating Files (6:56)
Deleting Files (5:41)
Copying FIles (9:19)
Moving Files (7:33)
Writing to Files (12:19)
Reading Files (6:47)
Reading CSV files (Comma Separated) (3:02)
Demo Scripts
Working with Excel Documents
Introduction (2:02)
Excel Object Model (Intro) (1:14)
Reading Excel Document - Part 1 (8:08)
Reading Excel Document - Part 2 (3:33)
Reading Excel Document - Part 3 (1:59)
Writing to Excel Document (11:19)
Create Workbook and Add Sheets (5:27)
Delete Sheets (3:24)
Count WorkSheets and Get WorkSheet names (4:47)
Determine the number of rows used and number of columns used (6:30)
Rename Worksheet (2:52)
Count Workbooks and Activate a desired WorkSheet (4:27)
Basic Formatting - Part 1 (4:46)
Basic Formatting - Part 2 (4:26)
Wrap Up! (0:55)
Demo Scripts
Upcoming Additions
Upcoming Topics
Writing to Files
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock