Get list of variable names in macros

Fri, 23 Sep 2011 10:27:46 GMT

Hi all,

Is there any way to get list of variables in macros.

actually i have a long list of variables and want to set values to them by looping through them?

Regards,

Sab

Re: Get list of variable names in macros

Miguel_Angel_Baeyens — Fri, 23 Sep 2011 10:47:51 GMT

Hi Sab,

Change the following macro code to set your variables properties or anything.

Sub ShowVars
     varNo = ActiveDocument.GetVariableDescriptions.Count - 1
     For i = 0 to varNo
          MsgBox(ActiveDocument.GetVariableDescriptions.Item(i).Name)
     Next
End Sub

Sub ShowVars
     varNo = ActiveDocument.GetVariableDescriptions.Count - 1
     For i = 0 to varNo
          MsgBox(ActiveDocument.GetVariableDescriptions.Item(i).Name)
          Set varActual = ActiveDocument.Variables(ActiveDocument.GetVariableDescriptions.Item(i).Name)
          varActual.SetContent varActual.GetContent.String + 2, true
     Next
End Sub

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Get list of variable names in macros

Fri, 23 Sep 2011 11:00:38 GMT

Hi Miguel,

Thats helps.

Thanks you very much.

Sab

topic Get list of variable names in macros in QlikView

Get list of variable names in macros

Re: Get list of variable names in macros

Get list of variable names in macros