topic Passing a Variable through a Select Statement in VB Ex. ActiveDocument.Fields("Date").Select("=$(Vdate)") in QlikView

Passing a Variable through a Select Statement in VB Ex. ActiveDocument.Fields("Date").Select("=$(Vdate)")

Thu, 10 Jun 2010 07:16:33 GMT

When you do a select (Or toggleselect) in a macro) you pass your value as such:

ActiveDocument.Fields("Date").Select("10/2/2010")

But what if i want to pass a variable through there? Like this:

My variable looks like this "vDate = 10/2/2010"

Code (VB):

Sub SelectDate

ActiveDocument.Fields("Date").Select("=$(vDate)")

End Sub

Is this possible, Is there a way around that, without using v9 (Actions), My client is on 8.5.

Thanks,

sparur — Thu, 10 Jun 2010 07:21:27 GMT

Hello

try that:

set q = ActiveDocument.fields("Date")
set v = q.GetVariable("vDate")

q.Select v.GetContent.string

Thu, 10 Jun 2010 07:33:44 GMT

Sorry but it came back with an error :Object doesn't support this property or method: 'q.GetVariable'"

Sub Sup

set q = ActiveDocument.fields("Year")

set v = q.GetVariable("vMonth")

q.Select v.GetContent.string

End Sub

Please assist.

sparur — Thu, 10 Jun 2010 08:08:34 GMT

sorry,

try that:

Sub Sup

set q = ActiveDocument.fields("Year")

set v = ActiveDocument.GetVariable("vMonth")

q.Select v.GetContent.string

End Sub