Yes - there are a lot of nice new features in the latest version, but unfortunately it takes a long time for us to get new software version deployed.
I've had another look at the code, and the Trend method to get values - I may just give it a try later.
Not seen the DevNet one but here is one I just knocked up, you can just build up couple of arrays based on the contents or create an Excel worksheet on the fly.
Sub ParseTrendValues(ByVal TheTrend As Trend)
Dim T As Integer
For T = 1 To TheTrend.TraceCount
TheTrend.CurrentTrace = T
Dim TV As Long
For TV = 1 To TheTrend.TraceValuesCount
Dim vTime As Variant, vStatus As Variant, vValue As Variant
vValue = TheTrend.GetTraceValue(TV, vTime, vStatus)
Debug.Print "Trace " & T & ", Tag:" & TheTrend.GetTagName(T) & ", Value:" & vValue & ", Time:" & vTime & ", Status:" & vStatus
That's really bad, as it is getting older by the second and sure it includes a lot of nice features and then some!
Hope you can deploy it soon.
Nobody tell the boss... but I got bored, so have written most of the code to copy the trend data to the clipboard.
The basic functionality works, but I need to sort out the error trapping etc.
I can post an example if anyone needs it.