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
Rename Worksheet
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock