Section 1 : introduction to VB Scripting
|
Lecture 1 | Introduction to VB Scripting | 00:10:07 Duration |
Section 2 : Creating VB Scripts
|
Lecture 1 | Creating and Running VB Scripts | 00:07:47 Duration |
Section 3 : Variables & Arrays
|
Lecture 1 | Variables and Constants | 00:20:47 Duration |
|
Lecture 2 | Arrays | 00:21:35 Duration |
Section 4 : Accepting Input From Users
|
Lecture 1 | Using inputbox | 00:17:33 Duration |
Section 5 : Operators
|
Lecture 1 | Using Operators | 00:03:08 Duration |
Section 6 : Conditional Statements
|
Lecture 1 | Using IF Statement | 00:19:51 Duration |
|
Lecture 2 | Using Select-Case Statement | 00:08:36 Duration |
Section 7 : Repeating Using Loops
|
Lecture 1 | Using do-while-until | 00:20:42 Duration |
|
Lecture 2 | Using for Loop | 00:07:41 Duration |
Section 8 : Using Procedures
|
Lecture 1 | Procedures - Part 1 | 00:06:58 Duration |
|
Lecture 2 | Procedures - Part 2 | 00:07:21 Duration |
|
Lecture 3 | Procedures - Part 3 | 00:10:51 Duration |
|
Lecture 4 | Procedures - Part 4 | 00:06:33 Duration |
|
Lecture 5 | Procedures - Part 5 | 00:08:08 Duration |
Section 9 : ByVal and ByRef
|
Lecture 1 | ByVal and ByRef - Part 1 | 00:09:55 Duration |
|
Lecture 2 | ByVal and ByRef - Part 2 | 00:07:25 Duration |
Section 10 : Using Built-in Functions
|
Lecture 1 | Using Built-in Functions - Part 1. | 00:10:17 Duration |
|
Lecture 2 | Using Built-in Functions - Part 2 | 00:07:57 Duration |
Section 11 : FSO - Understanding FilesystemObject
|
Lecture 1 | Introduction | 00:00:57 Duration |
|
Lecture 2 | What are File System Objects | 00:01:01 Duration |
|
Lecture 3 | What is Object Model | 00:08:16 Duration |
Section 12 : FSO - Working with Drives
|
Lecture 1 | Drives Introduction.mp4_1 | 00:00:47 Duration |
|
Lecture 2 | Basic Script | 00:02:51 Duration |
|
Lecture 3 | A Note About The Variable Names | 00:00:53 Duration |
|
Lecture 4 | Drives Script 01 - DriveLetter and Count | 00:03:51 Duration |
|
Lecture 5 | Drives Script 02 - Drive Space | 00:02:29 Duration |
|
Lecture 6 | Drives Script 03 - Drive Types, FileSystem Type an | 00:03:07 Duration |
|
Lecture 7 | Drives Script 04 - Serial Number and IsReady | 00:01:50 Duration |
|
Lecture 8 | Drives Script 05 - DriveExists | 00:02:19 Duration |
|
Lecture 9 | VBScripts-Drives-Ver1-09.28.2017 |
Section 13 : FSO - Working with Folders
|
Lecture 1 | Folders Introduction | 00:00:18 Duration |
|
Lecture 2 | Creating Folder | 00:03:48 Duration |
|
Lecture 3 | Copying Folder | 00:02:34 Duration |
|
Lecture 4 | Deleting Folder | 00:02:34 Duration |
|
Lecture 5 | Moving Folder | 00:02:02 Duration |
|
Lecture 6 | Getting Parent Folder Name | 00:01:37 Duration |
|
Lecture 7 | Getting Folder Information | 00:03:58 Duration |
|
Lecture 8 | VBScripts-Folders-Ver1-10.02.2017 |
Section 14 : FSO - Working with Files
|
Lecture 1 | Introduction | 00:00:18 Duration |
|
Lecture 2 | Files Fundamentals | 00:03:42 Duration |
|
Lecture 3 | Creating Files | 00:06:45 Duration |
|
Lecture 4 | Deleting Files | 00:05:41 Duration |
|
Lecture 5 | Copying Files | 00:09:08 Duration |
|
Lecture 6 | Moving Files | 00:07:17 Duration |
|
Lecture 7 | Writing to Files | 00:12:20 Duration |
|
Lecture 8 | Reading Files | 00:06:38 Duration |
|
Lecture 9 | Reading CSV Files | 00:02:54 Duration |
|
Lecture 10 | VBScripts-Files-Ver1-10.16.2017 |
Section 15 : Working with Excel Documents
|
Lecture 1 | Introduction | 00:02:02 Duration |
|
Lecture 2 | Excel Object Model (Intro)c | 00:01:15 Duration |
|
Lecture 3 | Reading Excel Document - Part 1 | 00:08:09 Duration |
|
Lecture 4 | Reading Excel Document - Part 2 | 00:03:33 Duration |
|
Lecture 5 | Reading Excel Document - Part 3 | 00:01:59 Duration |
|
Lecture 6 | Writing to Excel Document | 00:11:20 Duration |
|
Lecture 7 | Create Workbook and Add Sheets | 00:05:28 Duration |
|
Lecture 8 | Delete Sheets | 00:03:24 Duration |
|
Lecture 9 | Count WorkSheets and Get WorkSheet names | 00:04:47 Duration |
|
Lecture 10 | Determine the number of rows used and number of co | 00:06:30 Duration |
|
Lecture 11 | Rename Worksheet | 00:02:53 Duration |
|
Lecture 12 | Count Workbooks and Activate a desired WorkSheet | 00:04:27 Duration |
|
Lecture 13 | Basic Formatting - Part 1 | 00:04:47 Duration |
|
Lecture 14 | Basic Formatting - Part 2 | 00:04:26 Duration |