I would like to use instances of an AF template to hold various numeric/string values and/or PI points, and those values need to be read by and used in VBA calculations inside ProcessBook. (It would be more work, but instead of an object which holds point values, we could make do with just a string holding the name of the PI point - and we could implement the necessary value access in PB VBA.)
To date, the only way to do this that I've found is to create in PB an AF Dataset which can be mapped to an AF element - and the value from the Dataset read by PB VBA. But so far as I can tell, there can be only be one Element per PB AF Dataset. That would lead to hundreds of AF Datasets in a single .pdi file - which makes it seem like there should be a better way...
So - is there a way to have ONE PB AF Dataset contain all the elements from the template?
Or, is there a way to for PB VBA to 'connect' to AF and read elements directly - without going through a Dataset?
Or, is there some other way to move groups/sets of values from AF to PB?
Any insights - including "No way THAT is ever going to work" - will be appreciated.
jhcoxx