I am trying to search an Excel macro using PI OLEDB enterprise to get the AF DB data. Does anyone have a good example code of doing this? The example may have a "Connection String" setup, a good tested SQL script (e.g. using PI SQL Commander) in an Excel cell, query results on the worksheet, etc. It seems that these all can be done in manual way. My question is how can we put all such steps together to a Excel VBA code with some dialog boxes so that user can enter some query conditions with AF element / attribute search and others?
Thanks in advance,