Pune, India info@softwellautomation.com
+91-9175475416

VBScript Manual
Industrial VBScript Practical Manual

Official Philosophy: Open the software, open the Softwell Notebook, and perform the practical.

20 Practical Steps
Action Flow Manual
No Theory / Only Practical
Softwell Training Template

Softwell
Digital Practical
Notebook

[check] Open -> Click -> Select -> Download -> Test -> Complete

NO THEORY * ONLY PRACTICAL
P01

Softwell Digital Practical Manual

Practical 01 - Create First VBScript File

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create folder D:\Softwell_Training\VBScript.
v
02
STEP 02
Open Notepad or VS Code.
v
03
STEP 03
Create file hello-softwell.vbs.
v
04
STEP 04
Write a MsgBox statement showing Softwell VBScript Training.
v
05
STEP 05
Double-click the VBS file and verify the message box.

Expected Result

First VBScript file runs successfully using Windows Script Host.

Talk to Automation Advisor

Get expert guidance for course selection, corporate training, project support and practical learning path.

Course GuidanceSelect the correct PLC SCADA, corporate, online or Industry 4.0 path.
Batch SupportGet schedule, duration, mode and prerequisite guidance.
Project AdviceDiscuss plant, automation, reporting or training requirement.
P02

Softwell Digital Practical Manual

Practical 02 - Variables and Message Box

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Declare variables for trainee name, machine name and count.
v
02
STEP 02
Assign sample values to each variable.
v
03
STEP 03
Combine values into one message string.
v
04
STEP 04
Display the string using MsgBox.
v
05
STEP 05
Change values and run again to confirm dynamic output.

Expected Result

VBScript variables store and display dynamic training data.

Skills & Tools You Will Learn

Important automation skills are arranged for job-level, project-level and Industry 4.0 learning.

PLC ProgrammingLadder, SCL/ST, hardware, I/O mapping and troubleshooting.
SCADA / HMITags, screens, alarms, trends, scripts and reporting.
Industry 4.0 ToolsOPC UA, SQL Server, Python, dashboards and Excel/PDF reports.
P03

Softwell Digital Practical Manual

Practical 03 - Input Box Practical

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Use InputBox to ask for operator name.
v
02
STEP 02
Use InputBox to ask for batch number.
v
03
STEP 03
Validate that both values are not blank.
v
04
STEP 04
Display a final confirmation message.
v
05
STEP 05
Save the script as input-box-practical.vbs.

Expected Result

Script accepts operator input and displays a confirmation message.

P04

Softwell Digital Practical Manual

Practical 04 - If Condition Script

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create a variable named temperature.
v
02
STEP 02
Use If Then Else to compare temperature with high limit.
v
03
STEP 03
Display Normal when value is within limit.
v
04
STEP 04
Display Alarm when value is above limit.
v
05
STEP 05
Test the script with normal and alarm values.

Expected Result

Condition logic correctly separates normal and alarm values.

Why Choose Softwell Automation

Learn automation with practical examples, industrial troubleshooting approach and complete IT/OT learning path.

Industry Experienced TrainerReal plant examples and project based training.
Hands-on LearningPLC logic, SCADA, VFD, communication and reporting practice.
Flexible ModesOnline, classroom, corporate and in-plant options.
P05

Softwell Digital Practical Manual

Practical 05 - Loop Practical

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create a For loop from 1 to 10.
v
02
STEP 02
Build a text line for each scan count.
v
03
STEP 03
Display the final loop output.
v
04
STEP 04
Change the loop limit and run again.
v
05
STEP 05
Save the file as loop-practical.vbs.

Expected Result

For loop repeats logic and builds a scan count output.

Course Contents / Curriculum

The curriculum follows a practical sequence from fundamentals to project integration.

Level 01Basic PLC, wiring, addressing and ladder logic.
Level 02Advanced PLC, networking, SCADA and diagnostics.
Level 03OPC UA, SQL, Python, reports and IT/OT integration.
P06

Softwell Digital Practical Manual

Practical 06 - Create Text Log File

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create FileSystemObject.
v
02
STEP 02
Create a log file named machine-log.txt.
v
03
STEP 03
Write timestamp, machine name and status.
v
04
STEP 04
Close the file object properly.
v
05
STEP 05
Open the file and verify the log line.

Expected Result

VBScript creates a text log file with timestamped machine status.

Frequently Asked Questions About VBScript Manual Industrial VBScript Practical Manual

Who can join this training?

Students, freshers, working engineers, maintenance teams and corporate plant engineers can join based on their requirement.

Is practical training included?

Yes. The training is focused on PLC, SCADA, HMI, VFD, communication, troubleshooting and project based practice.

Can I request online or corporate training?

Yes. Softwell Automation provides classroom, online, corporate and in-plant training options.

P07

Softwell Digital Practical Manual

Practical 07 - Append Log File

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Open machine-log.txt in append mode.
v
02
STEP 02
Write three new machine status lines.
v
03
STEP 03
Use Now() for each timestamp.
v
04
STEP 04
Close the file after writing.
v
05
STEP 05
Confirm old and new log lines are present.

Expected Result

Script appends new log entries without deleting old records.

P08

Softwell Digital Practical Manual

Practical 08 - Read CSV File

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create a CSV file with Machine, Batch and Count columns.
v
02
STEP 02
Open the CSV using FileSystemObject.
v
03
STEP 03
Read line by line using a loop.
v
04
STEP 04
Split each line by comma.
v
05
STEP 05
Display or log parsed values.

Expected Result

VBScript reads and parses CSV production data.

P09

Softwell Digital Practical Manual

Practical 09 - Excel Automation Start

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create Excel.Application object.
v
02
STEP 02
Make Excel visible.
v
03
STEP 03
Create a new workbook.
v
04
STEP 04
Write report title in cell A1.
v
05
STEP 05
Save workbook as VBScript_Report.xlsx.

Expected Result

VBScript opens Excel, creates workbook and writes report heading.

P10

Softwell Digital Practical Manual

Practical 10 - Write Excel Report Rows

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Open the workbook created earlier.
v
02
STEP 02
Write column headings for Time, Machine, Count and Status.
v
03
STEP 03
Add at least five sample rows.
v
04
STEP 04
Apply bold formatting to headings.
v
05
STEP 05
Save and close the workbook.

Expected Result

Excel report is generated with headings and production rows.

P11

Softwell Digital Practical Manual

Practical 11 - SQL Connection Test

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create ADODB.Connection object.
v
02
STEP 02
Prepare SQL Server connection string.
v
03
STEP 03
Open connection to Softwell_Reports database.
v
04
STEP 04
Show success message if connection opens.
v
05
STEP 05
Close the connection safely.

Expected Result

VBScript connects to SQL Server successfully.

P12

Softwell Digital Practical Manual

Practical 12 - Insert SQL Record

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Open SQL connection.
v
02
STEP 02
Prepare INSERT query for ProductionLog.
v
03
STEP 03
Insert one sample production record.
v
04
STEP 04
Close the connection.
v
05
STEP 05
Verify the record in SQL Server Management Studio.

Expected Result

VBScript writes one production record into SQL database.

P13

Softwell Digital Practical Manual

Practical 13 - Read SQL Data

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Open SQL connection.
v
02
STEP 02
Create ADODB.Recordset.
v
03
STEP 03
Run SELECT TOP 10 query from ProductionLog.
v
04
STEP 04
Loop through recordset rows.
v
05
STEP 05
Display or write the rows into a text report.

Expected Result

VBScript reads SQL data and outputs report rows.

P14

Softwell Digital Practical Manual

Practical 14 - Generate Text Report

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create report file DailyReport.txt.
v
02
STEP 02
Write report title and date.
v
03
STEP 03
Add production summary lines.
v
04
STEP 04
Add alarm summary lines.
v
05
STEP 05
Close and open the report for checking.

Expected Result

Text report is generated automatically from script logic.

P15

Softwell Digital Practical Manual

Practical 15 - Send Email Script

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create CDO.Message object.
v
02
STEP 02
Set SMTP server details as per trainer instructions.
v
03
STEP 03
Set To, From, Subject and Body.
v
04
STEP 04
Attach a sample report file.
v
05
STEP 05
Send the email and verify delivery.

Expected Result

VBScript sends a report email using configured SMTP settings.

P16

Softwell Digital Practical Manual

Practical 16 - Error Handling

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Add On Error Resume Next at the controlled test block.
v
02
STEP 02
Try to open a missing file intentionally.
v
03
STEP 03
Check Err.Number after the operation.
v
04
STEP 04
Write error number and description to error-log.txt.
v
05
STEP 05
Clear Err after logging.

Expected Result

Script captures and logs runtime errors for troubleshooting.

P17

Softwell Digital Practical Manual

Practical 17 - Scheduled VBScript

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create a script that writes one timestamped report line.
v
02
STEP 02
Test the script manually.
v
03
STEP 03
Open Windows Task Scheduler.
v
04
STEP 04
Create a task to run wscript.exe with your VBS file path.
v
05
STEP 05
Run the task manually and check output file.

Expected Result

VBScript runs automatically using Windows Task Scheduler.

P18

Softwell Digital Practical Manual

Practical 18 - Folder Backup Script

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Create source and backup folders.
v
02
STEP 02
Use FileSystemObject to copy files from source to backup.
v
03
STEP 03
Add date and time to backup folder name.
v
04
STEP 04
Run the script and verify copied files.
v
05
STEP 05
Log backup success in a text file.

Expected Result

VBScript creates a dated backup of report files.

P19

Softwell Digital Practical Manual

Practical 19 - Integrated Report Script

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Read production data from CSV or SQL.
v
02
STEP 02
Write a formatted Excel report.
v
03
STEP 03
Save a text summary log.
v
04
STEP 04
Handle errors in error-log.txt.
v
05
STEP 05
Optionally email the generated report.

Expected Result

Integrated script produces a complete industrial reporting output.

P20

Softwell Digital Practical Manual

Practical 20 - Final VBScript Project

Philosophy: Open the software, open the Softwell manual, and perform the practical.

VBScriptAutomationReportsWindows Script
Software: Windows Script Host, Notepad / VS Code, Excel, SQL Server optional
Setup: Engineering laptop with Windows scripting enabled
01
STEP 01
Prepare folder structure, input data and report templates.
v
02
STEP 02
Run Excel report generation script.
v
03
STEP 03
Run SQL read or insert script.
v
04
STEP 04
Run backup and scheduler test.
v
05
STEP 05
Submit generated files and script source for review.

Expected Result

Final VBScript automation project is complete and demonstrated.

☎ Call WhatsApp ✉ Email Enquire Now