Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Export from excel into tags using VBS

Created by: Richard_ at: 6/7/2007 10:37 PM (4 Replies)

Rating (0)

Thanks 0

5 Entries

6/7/2007 10:37 PM	Rate (0)
Richard_ Posts: 4 Rating: (0)	Hi all. I’m new to this forum so be gentle. I am currently using Dat@monitor to read tags from WinCC into excel, & its works well.Does anyone know how best to export an amount of data back from excel into WinCC tags. I would appreciate if anyone could direct me toa simple example of VBS code or similar links. Regards Richard
Richard_ Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

6/8/2007 11:06 AM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	HI, I'm a bit confused here. You want to read data from an excel sheet and store that data into wincc Tags? Internal or external tags? with regards, ikkezelf
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

6/8/2007 1:26 PM	Rate (0)
Richard_ Posts: 4 Rating: (0)	Hi, I would like toread data from an excel report & transfer thisinto internal tags. My experience of VBS is limited. Regards Richard.
Richard_ Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

6/8/2007 2:26 PM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	Hi, Please search with google for excel/vbs related questions their are several hundred of them. When you knwo how to read the values from excel you can easily look in the wincc information files for the example of writing tags. I don't have any problem helping you, but it would be nice whne you at least give it a start yourself. Whenever you bumb into problems we can help you out. with regards, Ikkezelf EXAMPLES FROM WINCC INFORMATION FILE on how to write a tag: Example Asynchronous writing 'VBS104 Dim objTag Set objTag = HMIRuntime.Tags("Var1") objTag.Value = 5 objTag.Write MsgBox objTag.Value or 'VBS105 Dim objTag Set objTag = HMIRuntime.Tags("Var1") objTag.Write 5 MsgBox objTag.Value Synchronous writing 'VBS106 Dim objTag Set objTag = HMIRuntime.Tags("Var1") objTag.Value = 5 objTag.Write ,1 MsgBox objTag.Value or 'VBS107 Dim objTag Set objTag = HMIRuntime.Tags("Var1") objTag.Write 5, 1 MsgBox objTag.Value
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

6/11/2007 1:46 PM	Rate (0)
Richard_ Posts: 4 Rating: (0)	Thanks for your help. Regards Richard
Richard_ Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on