Error in Macro code

[spsrk_84]

Hi All,

I am working on QV 10 SR3 (64 bit) Qlikview Desktop .I am facing issue with the below code

Error Message :  Object required: 'ActiveDocument.Variables(...)'

sub GetActiveIndex

Set ContainerObj= ActiveDocument.GetSheetObject("CT30")

Set ContProp=ContainerObj.GetProperties      

vActiveIndex=ContProp.SingleObjectActiveIndex

ActiveDocument.Variables("vActiveIndex").SetContent vActiveIndex, true

msgbox vActiveIndex

End Sub

Please check the code  help to resolve this  issue in this code

Regards,

Shiva

[flipside]

Hi Shiva,

You need to get the variable as well as the object like this example in the API Guide ...

set v = ActiveDocument.GetVariable("Variable1")

v.SetContent "123",true

flipside

[spsrk_84 · Accepted solution]

The error occured because the variable vActive Index is not created .

[flipside]

Of course ... looks like there's two ways to set the variable!  I've gotten into the habit of always getting then setting.

set v = ActiveDocument.Variables("Variable1")

v.SetContent "123",true

flipside