Category
Scripting

Scripting

65 Articles
All tags
3D 61850 64 bits 7u51 AA Active Directory ActiveX Addon Adeunis ADO ADODB AE AI Alarm Alarm sythesis Alarm viewer Alarming Alarms Alert Animations ANSI Anywhere USB Applet Application Architect Application Explorer Applicom Architect Archive Archives Archiving ASCII Audit Autosize Average AVI BACnet Big data BMS Bottleneck Broadcast Byte Cassandra CFR21 Chart Control CHRONO Cimway Client Cloud CMMS Code Page Codec Comm.dat Command line Commend Communication Compatibility Configuration environment Copyfield Cosmos DB CRM Cron CSV Cyclic DALI Dashboard Data acquisition Data Export Database DataVue DBMS DCOM DDE DDE Server Debug Décret BACS Demo Demo project DEP DEV Diagnostic DirectLink DNP3 Documentation Domain Domain controller Dongle download Drawing Dream Report DVD extras EDE Email Enable Energy Equipment Error Error ID Error messages numbers ESXi Ethernet Ethernet direct Ethway EV Charge Event viewer Events Excel Export Expression FAQ File File Format Fipway Firewall Font Form FrontVue Gateway General GEZE Gmail Graphics Grid Groupalarm Handled Handles Hardcopy HDS Historic HMI HP IA prediction Icx IEC IEC 61850 IIS Iks Import Industry Installation Internet Internet Explorer Intravue IoT IP Izot Java JRE JSON Kerlink Key Keyboard KNX Language Legrand Libraries Library Licence Utility License License Utility Licensing LNS Log Log files Log viewer LogList Logoff LogViewer Lonworks LoRaWAN Memory Memory leak Messages Microsoft Microsoft SQL Server Migration Mimic Modbus TCP/IP Modem Molex Moxa MQTT MSSqlServer Multi-Station Multimedia Multiregion Multistation Multitech MXview MySQL NetBIOS Network Network analyser Networking News NL220 NoSQL Obsolete articles OCPP ODBC Offline OPC OPC UA OPC-DA Client OPC-DA Server Open source Open Weather Map Operating System Oracle Password PcVue PcVue 10 PcVue 12 PcVue as a service PcVue features PcVue11.2 PDF Performance PlantVue PLC Print Private Process Profibus Project management proprietary archiving Protect Tools Protocol Provider Proxy Pulse Quickstart Recipe Region Regular release Release info Replication Rest RLM RTE Ecowatt Russian S7 S7 Fetch/Write S7 ISO SAIA Sample project Scada Basic Schedule Scheduler Scripting Security Segmentation Sentinel Setup SG Siemens Sigfox Silent installation Simulation Single line diagram Smart Generator SMS SnapVue SNMP Social Network Solar Solar panel SQL SQL Server SQL Server 2014 Sql variables Start Startup String Substation Automation Summer SV Manager Toolkit Svmgr SW1000 Switch Syslog System Text TFTP Threads TIA Portal Time Timeout Timer Timestamp Toolkit Tools Touchscreen TouchVue Trace Treatments Trend Trend viewer Trends Troubleshooting TSDB UDC Unitelway Upgrade Useful tools Username Varconf.dat Varexp Variables VBA Version control Versions Virtual machine Virtualization VmWare VPN Vulnerability W7x64 WAGO Watchdog Weather Weather station Web Web Browser Web Services Web Services Toolkit Web.configsvmobile WebScheduler Webvue WhatsApp Windows domain Windows Terminal Server Windows update Winter Workaround Workspace Write Commands Xml Generic Import
Scripting

[KB591] How to read/write an INI file using SCADA BASIC

Applies to: PcVue all versions Summary: Two functions to read/write an INI file using SCADA BASIC Details: Two functions to read an INI style configuration file from PcVue. Supports any […]

1010
Scripting

[KB140] How to open windows in a particular region using SCADA Basic

Applies to: PcVue version 6.04 onwards. Summary: This article describes how to use SCADA Basic to control the opening of windows in selected regions. Details: There are 2 SCADA Basic […]

830
Scripting

[KB838] Populating the Grid with an SQL Request in VBA

Applies to: Versions of PcVue supporting VBA and the Grid control. Summary: How to display SQL Server trend table values in a grid control. With minor modifications this example could […]

1050
Scripting

[KB362] SCADA Basic Editor does not start

Applies to: PcVue all versions. Summary: SCADA Basic Editor does not start Details: When clicking the ellipsis (3 points) button, the editor window does not open. Two solutions can be […]

648
Scripting

[KB158] Incompatibility between VBA 6.2 and VBA 6.4

Applies to: PcVue version 8.00 SP3 onwards. Summary: This article identifies and gives a work-around for an incompatibility between versions 6.2 and 6.4 of Microsoft VBA. Solution: Until version 8.00 […]

611
Scripting

[KB1059] ActiveX Microsoft Web Browser in PcVue

Applies to: PcVue 7 onwards Summary: It is possible to use an ActiveX in order to navigate on a website inside a PcVue mimic. This way it is possible for […]

1364
Scripting

[KB716] Accessing SQL Server Database through VBA

Applies to: All VBA versions Summary: This VBA module allows to send read and write requests to a SQL Server database, using the ADO VBA Reference. The script is embbeded […]

1382
Scripting

[KB157] How to lock the Internet Explorer context menu for the Web Browser ActiveX

Applies to: PcVue version 7.00 onwards. While the basic content of this article remains valid, details may have changed since it was written. Summary: This article describes how to lock […]

1143
Scripting

[KB155] Defining an OLE DB Connection String for ADO Access via VBA

Applies to: PcVue version 7.20c onwards. While the basic content of this article remains valid, details may have changed since it was written. Summary: This article shows how to define […]

979
Scripting

[KB150] Using a Buffer with SCADA BASIC

Applies to: PcVue all versions. While the basic content of this article remains valid, details may have changed since it was written. Summary: This article gives advice on using buffers […]

835
Scripting

[KB149] How to Start an Excel Macro with a SCADA BASIC Instruction

Applies to: PcVue all versions. Summary: This article shows how you can start a macro with a SCADA BASIC instruction in PcVue. Details: For the example below, Excel must already […]

792
Scripting

[KB141] How to retrieve mouse coordinates in SCADA BASIC

Applies to: PcVue all versions. Summary: This articles describes how you can retrieve mouse coordinates in a PcVue project. Details: This uses the function GetCursorPos from a Windows DLL, USER32.DLL, […]

693
Scripting

[KB135] Launching an Excel workbook using an Enable Basic script

Applies to: PcVue version 7.00 onwards. This article contains obsolete references. Summary: This article describes how to launch a Microsoft Excel workbook using an Enable Basic script. Details: The sample […]

725
Scripting

[KB861] CHANGING AN IMAGE USING VBA

Applies to: PcVue 11.1 update and PcVue 11.2 update onwards Summary: A new VBA method, SetImage, allows the image file used in the Image drawing element to be changed programmatically.Originator: […]

703
Scripting

[KB1161] PcVue workspace adaptation on Windows resolution change

Applies to: PcVue version 12.0 onwards Summary: The decrease of Windows resolution makes PcVue reduce its workpace. How to readapt PcVue worspace if Windows resolution increases ? Details: A Typical […]

793
Scripting

[KB136] Printing a Window with Enable Basic VBscript

Applies to: PcVue version 7.00c onwards.This article contains obsolete references. Summary: This article outlines methods for printing a Window (or Mimic) with VBscript. Details: There are three ways to print […]

729
Scripting

[KB137] Retrieving memory information with Enable Basic

Applies to: PcVue version 7.00 onwards.While the basic content of this article remains valid, details may have changed since it was written. Summary: This article describes how to retrieve information […]

515
Scripting

[KB138] Changing a threshold value by a SCADA BASIC Program

Applies to: PcVue all versions. Summary: This article describes how to modify a threshold value of a register, using SCADA BASIC. Details: When a threshold value of a register variable […]

801
Scripting

[KB142] How to Send Messages to the Event Viewer

Applies to: PcVue all versions.While the basic content of this article remains valid, details may have changed since it was written. Summary: This article describes how to run a trace […]

827
Scripting

[KB143] How to start a SCADA Basic Program when a mimic opens

Applies to: PcVue all versions. Summary: This article describes how to make a SCADA Basic Program run when a particular mimic opens.From version 11.0 onwards it is not necessary to […]

1199
Scripting

[KB144] How to Increase the Number of Symbols in SCADA BASIC Programs and SCADA BASIC limitations

Applies to: PcVue all versions.While the basic content of this article remains valid, details may have changed since it was written. Summary: This article explains how to modify the limit […]

738
Scripting

[KB145] Limitations of the ‘IF’ instruction

Applies to: PcVue all versions. Summary: This article describes some limitations of the ‘IF’ instruction Details: In SCADA Basic you cannot combine a test of an register variable and bit […]

715
Scripting

[KB146] Logging of Alarm Acknowledgements

Applies to: PcVue version 6.04d onwards. Summary: This article describes how to attribute alarm acknowledgement from SCADA Basic to the current user. Details: It is possible to acknowledge alarms from […]

697
Scripting

[KB148] SQL Syntax for SVSQL SCADA Basic Instruction

Applies to: PcVue all versions.While the basic content of this article remains valid, details may have changed since it was written. Summary: This article outlines the SQL syntax to use […]

861
Scripting

[KB139] Date and time formats from SCADA Basic and VBA

Applies to: PcVue all versions. Summary: This article discusses discrepancies in the ways date-time formatting works in PcVue, SCADA Basic, VBA and animations. Details: Calculations of date and time do […]

1082
Scripting

[KB153] Adding a plug-in to VBA

Applies to: FrontVue all versions. PcVue version 7.20 onwards. Summary: This article describes how to add a powerful plug-in to VBA. Details: The VBA Editor enables you to add third […]

774
Scripting

[KB154] Bindable properties of external ActiveX

Applies to: PcVue version 7.00 onwards. Summary: This article indicates how to identify which properties of an external ActiveX can be linked to variables from the variables tree. Details: When […]

778
Scripting

[KB156] How to check whether a project is from a VBA version of PcVue

Applies to: PcVue version 7.20 to version 9.00. From version 10 onwards VBA was standard. Summary: This article describes how to tell from its mimic files whether a project came […]

602
Scripting

[KB159] Mimic templates with VBA/Enable scripts

Applies to: PcVue version 7.20 onwards. Summary: This article describes how to overcome a limitation concerning mimic templates with VBA/Enable scripts. Details: You can associate a script with a mimic […]

709
Scripting

[KB160] Restart PcVue with SvRestart.exe and VB script

Applies to: From PcVue version 7.00 to version 8.00 (incl.) Summary: This article describes how to restart a project with a VBscript procedure to call Restart_PcVue. Details: Open the attach […]

1276
Scripting

[KB161] Restriction on Symbols that Include VBA Code

Applies to: PcVue version 7.20a onwards. Summary: This article advises on a limitation on symbols that include VBA code. Details: If you create an instance of a symbol containing a […]

750
Scripting

[KB151] Using the “?VarName” syntax in SCADA Basic

Applies to: PcVue all versions. Summary: This article defines when you can use the syntax ‘?VarableName’ in SCADA Basic. Details: When you can use ‘?’ The syntax ‘?VariableName’ can only […]

743
Scripting

[KB162] Restrictions on executing VBA scripts

Applies to: PcVue version 7.20d onwards.While the basic content of this article remains valid, details may have changed since it was written. Summary: This article describes how to configure PcVue […]

821
Scripting

[KB152] Accessing extended attributes using VBA/Enable scripts

Applies to: PcVue version 7.20c onwards.While the basic content of this article remains valid, details may have changed since it was written. Summary: This article shows how to use VBA […]

918
Scripting

[KB163] UserForm cannot migrate between PcVue versions 7 and 8.

Applies to: PcVue version 7.20 VBA. Summary: This article indicates how to work around an incompatibility that affects VBA projects that contain UserForms. Solution: When you migrate a project from […]

581
Scripting

[KB164] VBA UserForms are not saved with mimics in ASCII format

Applies to: PcVue version 7.20 onwards. Summary: This article provides a work-around for the fact that when a mimic is saved in ASCII format, any VBA UserForm in it is […]

650
Scripting

[KB306] SCADA Basic function execution from VBA

Applies to: PcVue all versions. Summary: By forcing a variable in VBA code you can trigger a SCADA Basic function. By forcing a variable in SCADA Basic you can trigger […]

1352
Scripting

[KB320] When not to use SCADA Basic SYSTEM mode SYSTEM

Applies to: PcVue version 8.00 onwards. Summary: Do not use SYSTEM mode SYSTEM to launch a batch file which takes a long time to execute. For example a batch launching […]

731
Scripting

[KB321] VBA function DoEvent

Applies to: PcVue all versions. Summary: This article describes how to use the VBA function DoEvents and warns about the possible problems that can occur when using it. Details: The […]

1001
Scripting

[KB458] SCADA Basic Editor is invisible

Applies to: PcVue version 8.2 onwards. Summary: The SCADA Basic editor stores the most recent position of the editor window at the time it was last opened. If the window […]

697
Scripting

[KB476] SCADA Basic Limitations

Applies to: PcVue vesion 10.0.The basic content of this article may also be applicable to other versions of PcVue although the detail may vary. Summary: This article shows the SCADA […]

823
Scripting

[KB495] Memory leak when using the MULTIMEDIA instruction

Applies to: PcVue all VBA versions. Related articles: KB721 Summary: This article explains the handle (and memory) leakage due to the MULTIMEDIA instruction in SCADA BASIC. Note that there is another […]

1251
Scripting

[KB496] Running SCADA Basic functions

Applies to: PcVue all versions Summary: This article describes the sequence in which SCADA Basic functions are run when called simultaneously from different sources (via a button, action or cyclic […]

1223
Scripting

[KB506] How to access a VBA graphic object

Applies to: PcVue version 8.10 onwards Summary: Syntax to access a graphic object using a string variable Details: Please note that the graphic object does not have to be ticked […]

935
Scripting

[KB516] How to resize the AIGrid

Applies to: PcVue version 8.10 SP7 onwards. Summary: A sample VBA function to resize the AIGrid component after zoom or screen adaptation. Details: An example mimic after ZOOM OUT: The […]

583
Scripting

[KB530] SELECTOR instruction, new modes

Applies to: PcVue version 9.0 and 10.0. Summary: This article presents new SELECTOR modes. The new modes appeared in PcVue 9.0 but are not described in online help of some […]

709
Scripting

[KB550] How to temporarily disable database archiving

Applies to: PcVue version 8.10 onwards Summary: This article describes how to pause and resume HDS database archiving using VBA. (For proprietary archive units you must use the SCADA Basic […]

727
Scripting

[KB552] Chrono, UTC, Local hour in VBA

Applies to: PcVue all versions. Summary: This article contains a set of useful VBA functions for the conversion of datetime values from UTCtime to local time or Chrono values to datetime values and […]

1158
Scripting

[KB589] How to obtain the GMT offset using SCADA Basic

Applies to: PcVue version 10.0In general if a project is used with a later version of PcVue it will be automatically converted to that version. Occasionally it may be necessary […]

665
Scripting

[KB590] How to convert a time into the FILETIME format used by the HDS

Applies to: PcVue version 11 onwards. Summary: How to convert, using SCADA Basic, a Unix time (also known as Epoch time, Posix time…) to the FILETIME format as used by […]

987