I'm using PIDataLink 2013 in combination with Excel VBA. I have developed a macro which one will be executed when a button in the Excel-Sheet is pressed. Following a short extract of this code:
Function getAllValuesResult(ByVal tStartZeit As String, ByVal tEndZeit As String, ByVal tServer As String, ByVal tTagName As String) As String()
Dim tempResult As Variant
On Error GoTo MErr
tempResult = Application.Run("PICompDat", tTagName, tStartZeit, tEndZeit, 9, tServer, "inside")
MsgBox Err.Description, vbCritical, "Ausnahmefehler"
What I do is nothing more then using the Compressed Data Function of PIDataLink via VBA. The problem is that in tempResult most of the time the result is "Resize to show all values" and not the archived values.
For my understanding this message only appears when the result array is to small but in this case I haven't initialized an array with a defined array size. The second strange think is when I select the checkbox "Disable Resize to show all values messge" then this message never appears and everything looks good.
Hopefully somebody have an idea why this happens.