About hemanthv

hemanthv

Hi Andrew, ExcelCommand.bat is @echo Off cscript.exe "C:\Hawk Backups\bch.vbs" > c:\Hawk Backups\log.txt @echo on bch.vbs file contains Set objExcel = CreateObject("Excel.Application") objExcel.Application.Run "'C:\Hawk Backups\batch.xlsm'!Module1.Macro1" objExcel.DisplayAlerts=False objExcel.Application.Quit Set objExcel = Nothing

hemanthv

Hi Andrew, I have tried the following PROGRAM SynchReportDirectories VAR Synch, Synch2: DINT; END_VAR; Synch:= SYSTEM('"C:\Windows\System32\cmd.exe" "C:\Hawk Backups\EXCEL_EXPORT\excelcommand.bat"'); END_PROGRAM But in system status windows - it is timing out. also tried cscript.exe and passing the file - it showed success but did not execute the file. i have attached snapshot of system status,

hemanthv

Hi, i have the following scripting program. I would like to call it depending on specific condition like day end or hour end. so that excel macro is executed which query clearscada for data and print it to a folder. Only problem i have is how to execute using a scheduler or a ST program. is there is mechanism to execute it? Public Sub ExceltoPDF() Dim objExcel Set objExcel = CreateObject("Excel.Application") objExcel.Application.Run "'C:\Hawk Backups\batch.xlsm'!Module1.Macro1" objExcel.DisplayAlerts=False objExcel.Application.Quit Set objExcel = Nothing End Sub thanks regards,

hemanthv · ‎2020-04-09

thank you all..!

hemanthv · ‎2020-04-06

Hi, we have a systems with 24550 tags counts. We have noticed that there are multiple number of files in Journal folder and total size increase to 6GB. 1. How to reduce the number of files. 2. How do I reduce the file size or increase the file size. 3. How to optimize the file size to improve data transfer between redundant servers. 4. Is it possible to get all historical enable tags using SQL script.

hemanthv · ‎2020-02-04

I will limit the input using Min and Max settings the variable and depending on the final result of Y will make the value blink red. thanks.

hemanthv · ‎2020-02-04

Crystal reports

hemanthv · ‎2020-02-04

Crystal report displayed with graph..

hemanthv · ‎2020-02-04

Yes, as per your last post.. Tried to use X-Y Trend. X and Y values where in manually entered using ST with Time stamp. Once done same was mapped onto X-Y Trends. I was stuck with one problem. How to manually change the time to specific time using script on X-Y Trends. Other option which also works is Storing information using ST in DataTable with X,Y columns and Displaying them on Crystal Reports directly. SQL Query Functions to insert values into DataTable. I will try the Dynagraph but as of now we are going to settle with Option of crystal reports. Thanks.

hemanthv · ‎2020-02-04

Hi, i am looking for how to display X-Y plot on ClearSCADA Trends not over a time line. Some thing similar to one as attached.

Online Status	Offline
Date Last Visited	Wednesday

About hemanthv

Re: How to call a Vbscript program either by ST

Re: How to call a Vbscript program either by ST

How to call a Vbscript program either by ST

Re: Reducing the size of historical / Alarm Summary files on PC.

Reducing the size of historical / Alarm Summary files on PC.

Re: Pop up message depending on an internal variable being set.

Re: Display X-Y plot without time line.

Re: Display X-Y plot without time line.

Re: Display X-Y plot without time line.

Display X-Y plot without time line.

Support

FAQ

About