Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

By using the daily action, the value of the tags is not entered in the Excel field.

Created by: Elyas at: 2/20/2023 1:01 PM (3 Replies)

Rating (0)

Thanks 0

4 Entries

2/20/2023 1:01 PM	Rate (0)
Elyas Experienced Member Joined: 1/7/2013 Last visit: 1/20/2025 Posts: 26 Rating: (0)	Hello mmhamunkar I used your program, but the problem is that by using the daily action, the value of the tags is not entered in the Excel field. What do you think is the problem? ------------------------------------------------------------------------------------------ Split from Wincc tag export into excel by VBS script .
	Last edited by: Jen_Moderator at: 02/22/2023 13:26:31 New subject after splitting
Suggestion To thank Quote Answer

2/21/2023 1:11 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 1/20/2026 Posts: 16653 Rating: (1944)	Elyas Hello mmhamunkar I used your program, but the problem is that by using the daily action, the value of the tags is not entered in the Excel field. What do you think is the problem? Hello Elyas What exactly goes wrong in your script? Use APDiag to identify in which line there is a problem? Also do you have check with the basic example of the MS Automation interface for Excel in the WinCC Help System if your interaction with excel works basically? (just to say it does not work is not a good start for diagnostic) Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

2/22/2023 8:39 AM	Rate (0)
Elyas Experienced Member Joined: 1/7/2013 Last visit: 1/20/2025 Posts: 26 Rating: (0)	Hello MUROF You are right. I correct: The program that I have used works correctly with mouse action, but if I activate the time trigger, which reports for example every day at 7 am, the file is created in the corresponding folder, and the headers are also created, but the tag values are not. It is written like this: Option Explicit Function action Dim ProjectPath Dim ProjName Dim FileName Dim FSO, GF, OTS Dim TitleStr Const ForReading = 1, ForWriting = 2, ForAppending = 8 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 Dim TagValue ProjPath = "F:\" FileName = ProjPath & "\ReportScale2\REPORT2" & ".csv" Set FSO = CreateObject("Scripting.FileSystemObject") If FSO.FolderExists(ProjPath & "\ReportScale2") = False Then FSO.CreateFolder(ProjPath & "\ReportScale2") End If If FSO.FileExists(FileName) = False Then FSO.CreateTextFile(FileName) Set GF = FSO.GetFile(FileName) Set OTS = GF.OpenAsTextStream(ForAppending,TristateUseDefault) OTS.WriteLine "Date,Counter 1,Scale 1,Scale 2,Scale 3" OTS.Close End If If FSO.FileExists(FileName) = True Then Set GF = FSO.GetFile(FileName) Set OTS = GF.OpenAsTextStream(ForAppending,TristateUseDefault) TagValue = CStr(Date) & "," Dim COUNTER1 Set CUNTER1 = SmartTags("CUNTER1") TagValue = TagValue & CUNTER1.Value & "," Dim SCALE1 Set SCALE1 = SmartTags("SCALE1") TagValue = TagValue & SCALE1.Value & "," Dim SCALE2 Set SCALE2 = SmartTags("SCALE2") TagValue = TagValue & SCALE2.Value & "," Dim SCALE3 Set SCALE3 = SmartTags("SCALE3") TagValue = TagValue & SCALE3.Value & "," '_________________________ OTS.WriteLine TagValue OTS.Close End If End Function

Suggestion To thank Quote Answer

2/22/2023 2:25 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 1/20/2026 Posts: 16653 Rating: (1944)	Hello Elyas Which WinCC Version do you use? If you use WInCC V7.X you should not use SmartTags in scripts Check how you should read and write TAgs in VB Script in the manual: https://support.industry.siemens.com/cs/ww/en/view/109792622/45951188235 Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on