Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'd need to have the selected field-selection pairs from the activesheets current selection box, however I could not manage to access to the CS boxes through ActiveDocument.Activesheet.GetCurrentSelections.
I tried the below in Qlik and got an "object required" error + in python with COM, the result was an empty tuple.
sub d
x = ActiveDocument.ActiveSheet.GetCurrentSelections // tried with set x too..
s = x.Selections
v = x.VarId
for i = lbound(s) to ubound(s)
msgbox v(i)&" = "&s(i)
next
end sub
Any help is appreciated,
thx,
try this:
sub d
x = ActiveDocument.GetCurrentSelections
s = x.Selections
v = x.VarId
for i = lbound(s) to ubound(s)
msgbox v(i)&" = "&s(i)
next
end sub
I tried, but the result is not the active sheets current selection box, but the first sheets selections. I suppose there is a reason why we have activesheet.getcurrentselection separately in the API guide?
Actually what I dont understand is why I get the object required error, as I have the same code as in the guide