String value in a select statement VBA

Fri, 24 Sep 2010 15:40:30 GMT

How can i get the "strValue" in the place of the 38.

I need to make a selection with i from last week until te the first week.

"<38" works

(< strValue) gives a faillure.

Sub setWeektotnuToe()
set v = ActiveDocument.Variables("HuidigeWeek")
strValue = v.GetContent.String
ActiveDocument.Fields("Week").Select "<38"
End Sub

String value in a select statement VBA

Fri, 24 Sep 2010 15:54:25 GMT

Sub setWeektotnuToe()
set v = ActiveDocument.Variables("HuidigeWeek")
strValue = v.GetContent.String
ActiveDocument.Fields("Week").Select "<"+(strValue)

End Sub

Is the sollution

Bye

topic String value in a select statement VBA in QlikView

String value in a select statement VBA

String value in a select statement VBA