VBScripting Fundamentals
Windows Automation Made Easy!
|
|
|
|---|
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 not only benefits regular users (wanting to experiment), but also QTP/UFT professionals. Without any question, VB Scripting enables QA Engineers to move their efficiency to a NEXT LEVEL. VB Scripting is heavily used in QTP/UFT environment. In addition, System Administrators & Programmers use VB Scripting to automate system administrator tasks daily.
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!!
Course Curriculum
Introduction to VBScripting
Available in
days
days
after you enroll
Creating VB Scripts
Available in
days
days
after you enroll
Variables & Arrays
Available in
days
days
after you enroll
Accepting Input From Users
Available in
days
days
after you enroll
Operators
Available in
days
days
after you enroll
Conditional Statements
Available in
days
days
after you enroll
Repeating Using Loops
Available in
days
days
after you enroll
Using Procedures
Available in
days
days
after you enroll
ByVal and ByRef
Available in
days
days
after you enroll
Using Built-in Functions
Available in
days
days
after you enroll
FSO - Understanding FilesystemObject
Available in
days
days
after you enroll
FSO - Working with Drives
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
FSO - Working with Files
Available in
days
days
after you enroll
Working with Excel Documents
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
Browse Other Courses
EXAMPLE
