Auto change tags in PITrend

Discussion created by AztecTechnologies on Mar 2, 2010
Latest reply on Mar 3, 2010 by AztecTechnologies

Hi All,


When a PI Trend (PITrend1_Sheet1) is inserted in excel worksheet, two object are created PIArchiveData1_Sheet1 and PIExcelData1_Sheet1 if we chose the data source to be both PI and worksheet respectively .


Is there any way to modify/add/remove tags in PIArchiveData1_Sheet1 and change the range in PIExcelData1_Sheet1 in VBA?


This is useful when dealing with reports that require different tags and excel source data range.




Please reply