WinCC VBScript · HMIRuntime · GLOBAL SCRIPT · ADODB & EXCEL REPORTING
A scripting course for WinCC engineers who have hit the limits of configuration. Start with VBScript itself — syntax, data conversion, decisions, loops, arrays and procedures — then connect to the running station through HMIRuntime tag access, global script actions and triggers, faceplates and proper error handling. Apply it to alarms, validated operator input and recipes, and finish by moving runtime data into SQL Server with ADODB, CSV files and formatted Excel reports.
Classroom day batches · Online 7:30 PM–9:00 PM · Sunday 11:00 AM–5:00 PM
See the editors, runtime objects and practical scripting topics used at each stage of the WinCC VBScript path. Select a module to view exactly what you will work with.
Training progression: Module 01 teaches the VBScript language itself, Module 02 connects it to the running station through HMIRuntime tags, actions and faceplates, Module 03 applies it to alarms, operator input and recipes, and Module 04 turns runtime data into SQL records, CSV files and Excel reports.
View Detailed VBScript Training Contents →The scripting course is organised as four practical modules covering 19 WinCC VBScript topics. Every topic below is a written guide with working script you can open before or after the session — from language syntax through HMIRuntime tag access and faceplates to alarms, recipes, SQL Server and Excel reporting.
Learn the language before the runtime: keywords and syntax, variables and data conversion, decisions, loops and arrays, and procedures with ByVal and ByRef so scripts stay readable and reusable.
The working syntax reference: statements, keywords, declarations and the writing conventions that keep WinCC scripts maintainable.
View training topic →02Variant behaviour, operators and explicit conversion with CInt, CDbl and CStr — the single biggest source of silent script bugs in WinCC.
View training topic →03Decision logic that reads clearly at 2 a.m.: nested IF versus Select Case, and when each belongs in a runtime action.
View training topic →04Iterate over tag lists and screen objects with FOR and Do While, and size arrays dynamically with ReDim Preserve.
View training topic →05Write procedures that return values cleanly, understand argument passing, and build a script library instead of copy-pasting code.
View training topic →Connect scripting to the running SCADA station: read and write tags through HMIRuntime, configure global actions with the right triggers, drive screen navigation and faceplates, and handle errors properly.
The core runtime skill: read tag values, write back safely, check quality and avoid blocking the runtime with slow tag access.
View training topic →02Create global actions in the VBS editor, choose cyclic or tag triggers, and keep script load low enough that runtime stays responsive.
View training topic →03Script screen changes and faceplate instances so one object serves every pump or valve instead of duplicated screen logic.
View training topic →04A structured object model lab: screens, objects, properties and methods worked through step by step in WinCC Explorer.
View training topic →05On Error Resume Next used correctly, error checks, trace output and the diagnostic habits that stop a silent script failure.
View training topic →Apply scripting to the jobs operators and plant teams actually need: alarm and event handling, validated operator input with command gating, and recipe or batch parameter management.
React to alarms and events in script: acknowledgement handling, filtering and driving actions from the message system.
View training topic →02Validate entries against limits and machine state before they reach the PLC, and gate commands so an unsafe action is never written.
View training topic →03Load, transfer and store recipe and batch parameters through script so product changeover needs no engineering edit.
View training topic →04Where scripting earns its place in a real project — and where a standard WinCC feature does the job better than code.
View training topic →Turn runtime data into records and reports: connect to SQL Server with ADODB, run full CRUD operations, export tag data to CSV and generate Excel reports directly from WinCC.
Build the database and table structure for plant data from script, with connection strings and authentication handled correctly.
View training topic →02Insert, select, update and delete records from runtime with parameterised statements, recordset handling and clean connection closing.
View training topic →03Write tag values to CSV with timestamps and a fixed column layout that Excel and downstream systems can read without cleanup.
View training topic →04Drive Excel from WinCC to produce a formatted shift or production report, with headers, values and file naming handled in script.
View training topic →05The capstone set: 28 worked examples covering tags, screens, alarms, recipes, files and database access for self-practice after the sessions.
View training topic →VBScript extends a WinCC SCADA station beyond what configuration alone can do: reading and writing tags at runtime, reacting to alarms and events, validating operator input, handling recipes, navigating screens and faceplates, and moving data into SQL Server, CSV files or Excel reports.
WinCC Explorer V8.1 with the Global Script VBS editor. The scripting concepts and the HMIRuntime object model also apply to earlier V7 projects, so existing plant stations can be maintained with what you learn here.
No. The first module covers VBScript from syntax, variables and data conversion through decisions, loops, arrays and procedures before any runtime object is touched, so SCADA engineers with no coding background can follow it.
Yes. HMIRuntime tag access is the core runtime skill of the course, including value and quality checking, write-back behaviour, and how to avoid slow or blocking tag access that makes a runtime feel sluggish.
Yes. Global actions and screen actions are configured with cyclic and tag triggers, and the course covers script execution load directly, because badly triggered actions are the most common cause of poor WinCC runtime performance.
Yes, as a full module. Connection strings and authentication, creating databases and tables, insert, select, update and delete operations, recordset handling and proper connection closing are all worked through with practical scripts.
Yes. The course covers CSV export of tag data with timestamps and a fixed column layout, and Excel automation from WinCC to produce formatted shift and production reports with headers, values and controlled file naming.
Yes. An object-based practice lab manual and a set of 28 worked SCADA examples cover tags, screens, alarms, recipes, files and database access so you can keep practising on your own station.
Classroom sessions run in the day batches and live online sessions run from 7:30 PM to 9:00 PM on weekdays, with a Sunday batch from 11:00 AM to 5:00 PM. Corporate and in-plant groups can request a different schedule.
Send your requirement for WinCC VBScript training. Mention your WinCC version, whether you need runtime scripting, database access or report generation, and your current programming level, so the scripts written in the sessions match your station. Online batch runs 7:30 PM to 9:00 PM on weekdays and 11:00 AM to 5:00 PM on Sunday.
Explore the four scripting modules, the WinCC version used in the sessions, the database and reporting labs and classroom or online batch options.
Content reviewed: 18 September 2026