Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Populate tag value with spreadheet data

Created by: GrahamS at: 4/23/2007 3:29 PM (5 Replies)

Rating (0)

Thanks 0

6 Entries

4/23/2007 3:29 PM	Rate (0)
GrahamS Posts: 17 Rating: (0)	Hi All, I am currently using data in Spreadsheet to populate IOField. Instead of a IOField I would like to use a external tag. Could you please advise. ScreenItems ("IOField6").OutputValue = objExcelApp.Cells(1, 5).Value
GrahamS Posts: 17 Rating: (0)
Suggestion To thank Quote Answer

4/23/2007 3:33 PM	Rate (0)
Danielle Posts: 1275 Rating: (123)	Hi, You could send the data from the I/O Field or a static text to the tag... is this what you need?
Danielle Posts: 1275 Rating: (123)
Suggestion To thank Quote Answer

4/23/2007 3:52 PM	Rate (0)
GrahamS Posts: 17 Rating: (0)	I want to get data from a cell in a xls document and then write that value to a tag. In the above exampe I can write from a cell in an xls documentand populate an IO field. Cheers,
GrahamS Posts: 17 Rating: (0)
Suggestion To thank Quote Answer

4/23/2007 4:20 PM	Rate (0)
Danielle Posts: 1275 Rating: (123)	Hi, HMIRuntime.Tags("tag").Write objExcelApp.Cells(1, 2).Value This gets the value from the field 1,2 and writes to the tag. Best regards, Danielle
Danielle Posts: 1275 Rating: (123)	Last edited by: Danielle at: 23.04.2007 16:21
Suggestion To thank Quote Answer

4/23/2007 4:31 PM	Rate (0)
GrahamS Posts: 17 Rating: (0)	Thanks, that works a treat. I was using an =. HMIRuntime.Tags("Tag").Write= objExcelApp.Cells(1, 1).Value
GrahamS Posts: 17 Rating: (0)
Suggestion To thank Quote Answer

4/23/2007 4:38 PM	Rate (0)
Danielle Posts: 1275 Rating: (123)	I put the "=" at first too, but then I remembered to take it off.
Danielle Posts: 1275 Rating: (123)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on