Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I'm looking to grab / fetch a specific value of a row / column from a table object, for use in another object.
So lets say I have a table object with ID of OBJECT1.
In another object, say a text object, I want to say something like: =OBJECT1.Column(2) and simply display the number which exists in that column/row of object 1.
Any way to do this?
Dan
 
					
				
		
Bump. Can anyone help?
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can't directly refer an object row in qv like that. You should rather refer the data considering it's POV. Otherwise, there is macro, somthing like:
set obj = ActiveDocument.GetSheetObject( "BU01" )
CellRect = ActiveDocument.GetApplication().GetEmptyRect()
CellRect.Top = 0
CellRect.Left = 0
CellRect.Width = obj.GetColumnCount
CellRect.Height = obj.GetRowCount
set CellMatrix = obj.GetCells( CellRect )
for RowIter=CellRect.Top to CellRect.Height-1
for ColIter=CellRect.Left to CellRect.Width-1
msgbox(CellMatrix(RowIter)(ColIter).Text)
next
next
