IMPORTANT: Use VBA to get VALUE of result objects?

[mortac8]

Is there any way to get the actual values of result objects (not just the name) using VBA? Please advise!

Any ideas are GREATLY appreciated!


Below: In the BOSDK documentation it describes the Result Class. But it only allows you to get the name of the class and the name of the object...I need the value of the objects.


Dim i As Integer
Dim qry As Query
resultlist = "The results for the first query are:" & Chr(10) & Chr(10)
Set qry = Application.ActiveDocument.DataProviders.Item(1).Queries.Item(1) 'qry is the first query in the Queries collection
For i = 1 To qry.Results.Count 'For the results in the collection
resultlist = resultlist & qry.Results.Item(i).Class & " - " & qry.Results.Item(i).Object & Chr(10) 'and the object
Next i
MsgBox resultlist 'display the results