Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am writing a set of VBA codes to QC my QlikView tool and in the process of doing so I am stuck at a point which is: VBA code to click on TextObject.
I tried two options:
1. QVDoc.GetSheetObject("TXT1").Press
2. QVDoc.GetSheetObject("TXT1").Activate
but both are not working.
Regards
Sagar Gupta
It's not possible. The com api doesn't have an interface for click events of sheet objects except for the button.
I tried something where we can create a button which has all actions for that text object, then press that button and then delete it. This gives the same functionality.
Function TextObjClick(tx As String)
Dim newbutton
Dim prop
Dim TextActions
Dim i
Dim ButtonActions
Set newbutton = QVDoc.ActiveSheet.CreateButton
Set prop = newbutton.getproperties
prop.Text.v = QVDoc.GetSheetObject(tx).GetText
Set ButtonActions = prop.ActionItems
Set TextActions = QVDoc.GetSheetObject("TX01").getproperties.Layout.ActionItems
Dim actionparam
Dim j
For i = 0 To TextActions.Count - 1
ButtonActions.Add
ButtonActions.Item(i).Type = TextActions.Item(i).Type
Set actionparam = ButtonActions.Item(i).Parameters
For j = 0 To TextActions.Item(i).Parameters.Count - 1
actionparam.Add
actionparam.Item(j).v = TextActions.Item(i).Parameters.Item(j).v
Next
Next
newbutton.SetProperties prop
newbutton.press
newbutton.Close
End Function