Is there a way to call AF Builder functions from a VBA script programmatically?
I would like to automate some templates using AF Builder.
Can we use directly any existing functions like Export to AF in VBA?
As far as i'm aware, it's not possible.
Even if that would be possible, once you start coding in my opinion you are better off to build the translation logic between the Excel-sheet and PI AF using the AFSDK from VBA.
The PI Builder doesn't expose functions in Excel like DataLink. It is possible to call AFSDK methods PISystem.ExportCsv() and PISystem.ImportCsv(), however.
Retrieving data ...