VBA - Current Selection Box

[LaIs]

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, 

[Frank_Hartmann]

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

[LaIs]

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