Read/Writing to tag in FTV SE using VBA

[Adam83]

Hi

Im currently upgrading a PV1200 project to FTV SE 5.0, and need to know how to read and write directly to tags from VBA.

I can read a tag's value when i link it to a numeric input by using,

NumericInputname.value

but if i want to write to that value i cant do

NumericInputname.value = 1


There has to be a simple way to reference tags etc in vba. like citect for example had the TagRead/TagWrite functions.

is there anything like

TagDatabase.Tag("Tagname").value = 1???


Thanks

Adam

 

[klikopc]

I don't know the program that you are using, but i have worked with VBA before.

You need either an activex or a .dll library compatible with VBA to access controller variables.

If the "FTV SE 5.0" program already has a default library for variable linking, look into the object browser in VBA Editor(View->Object Browser) and search for a function like Write or WriteVariable, then just use the function!

Give me more details if you want more help

Matic

 

[jkerekes]

You need to create a TagGroup. For example:

Set TagGroup = CreateTagGroup(Me.AreaName, 500)
TagGroup.Add "[" & TopicName & "]" & TagName & "_D2SD.ProgOper"

TagGroup.Add "[" & TopicName & "]" & TagName & "_Motor.AlarmMotorFault"

TagGroup.Active = True

TagsOK = TagGroup.RefreshFromSource(TagsInError)

DeviceMode = TagGroup(1).Value
MotorFault = TagGroup(2).Value

 

[Adam83]

You need to create a TagGroup. For example:

Set TagGroup = CreateTagGroup(Me.AreaName, 500)
TagGroup.Add "[" & TopicName & "]" & TagName & "_D2SD.ProgOper"

TagGroup.Add "[" & TopicName & "]" & TagName & "_Motor.AlarmMotorFault"

TagGroup.Active = True

TagsOK = TagGroup.RefreshFromSource(TagsInError)

DeviceMode = TagGroup(1).Value
MotorFault = TagGroup(2).Value

Thanks Kerekes,

I have done as you specified and it seems to be working.

Thanks for the help.