Hi all,
Please help me on below
Below Macro functionality is once i am providing the input for row and column (Using Inputbox) from the Qlikview UI then corresponding text box i am getting value of the corresponding row and column .
Can someone enhance this macro so i can capture all the columns values inside a Chart.
Please find the attached screenshot where i kept the existing Macro functionality screen shot and aspect Functionality Screenshot.
Sub ChangeV1
set table = ActiveDocument.GetSheetObject( "TB01" )
CellRect = ActiveDocument.GetApplication().GetEmptyRect()
CellRect.Width = table.GetColumnCount
CellRect.Height = table.GetRowCount
set CellMatrix = table.GetCells(CellRect)
r = Activedocument.variables("r").Getcontent.String
c = Activedocument.variables("c").Getcontent.String
set cell = CellMatrix.Item(r).Item(c-1)
Activedocument.variables("v1").SetContent cell.text,1
End Sub
Thanks and Regards
Balram
