Blog Gallery Downloads Pune, India
+91-9175475419 info@softwellautomation.com

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.

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.

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.

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.

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.

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 ✉ Enquire Now