Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Script VBS to export to Excel doesn't work

Created by: Kaveh_K at: 8/7/2014 8:08 AM (3 Replies)

Rating (0)

Thanks 0

4 Entries

8/7/2014 8:08 AM	Rate (0)
Kaveh_K Posts: 12 Rating: (0)	Hi Experts, I want to export some tags from WinCC to Excel and as a simple exampel use the following code: Sub ExportExcel() Dim tagName, tagValue, tagFilename Dim strFilename, strLine Dim arrTags(4), i Dim fso, objFile, objTag arrTags(0) = HMIRuntime.Tags("PLC01/TI-2112.wval") arrTags(1) = HMIRuntime.Tags("PLC01/TI-QDELAY.T01") arrTags(2) = HMIRuntime.Tags("PLC01/TI-QDELAY.T02") arrTags(3) = HMIRuntime.Tags("PLC01/TI-QDELAY.T03") arrTags(4) = HMIRuntime.Tags("PLC01/TI-QDELAY.T04") Set tagFilename = HMIRuntime.Tags("C:/Temp/FileA.txt") strFilename = tagFilename.Read Set fso = CreateObject("Scripting.FileSystemObject") Set objFile = fso.CreateTextFile(strFilename,True) 'for control HMIRuntime.Trace("VB-Script: Write file: " & strFilename & vbCrLf) For i=0 To 4 Set objTag = HMIRuntime.Tags(arrTags(i)) strLine = arrTags(i) & ";" & objTag.read objFile.WriteLine strLine 'for control HMIRuntime.Trace(strLine & vbCrLf) Next objFile.Close End Sub but it seems the program is not activated at all and doesn't make FileA.txt, Is there any code needs to activate the VBS? is there anything wrong in my program? Thanks for help
Kaveh_K Posts: 12 Rating: (0)	Last edited by: CS Moderator at: 8/8/2014 10:37 AM new subject after splitting from /tf/WW/en/Posts/1619#top
Suggestion To thank Quote Answer

8/7/2014 9:35 AM	Rate (0)
Kaveh_K Posts: 12 Rating: (0)	Hi Experts, I have problem in activating the VBS code, how should we activate it. I looked at some documents and i think i need Cyclic trigger but i don't know how can i use cyclic actions
Kaveh_K Posts: 12 Rating: (0)	Last edited by: CS Moderator at: 8/8/2014 10:41 AM new subject after splitting from /tf/WW/en/Posts/57884#top
Suggestion To thank Quote Answer

8/19/2014 1:41 PM	Rate (0)
Gärchla Posts: 457 Rating: (46)	Hello Kaveh, open Global Script VBS, File: New Action, at the right end of Icon Bar there is a clock symbol. set properties of clock symbol. Best regards Georg
Gärchla Posts: 457 Rating: (46)
Suggestion To thank Quote Answer

8/19/2014 3:10 PM	Rate (0)
NitinG66 Posts: 18 Rating: (1)	Or else, if your Run-Time is ON, change the graphics screens. Script will execute. Nitin G.
NitinG66 Posts: 18 Rating: (1)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Related topics by keywords:

WinCC Scripting

Follow us on