I think I am starting to figure things out for my project. I am working with VBA is Excel. This code works for the time being but there are a couple of more things I would like to accomplish.
Set pt = server.PIPoints(tagarray(i - 1))
Set pivalues = pt.Data.InterpolatedValues(StartDateTime, EndDateTime, 4000, "")
1. Rather than specifying 4000 data points, I would like to get the data returned with a specific period (i.e. "1h") between startdatetime and enddatetime. It doesn't look like InterpolatedValues2 is available.
2. Wrt to filtering, is there document that would have some good examples on specifying the filtering. I would like to only retrieve data when a different tag is at a specified value or between two values.