AnsweredAssumed Answered

Is there a Excel 2010 VBA code example using PI OLEDB Enterprise?

Question asked by chuyiyang on Jun 29, 2015
Latest reply on Jul 1, 2015 by Eugene Lee

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,

Chuck Yang

Outcomes