Change Expression Condition with Macro VB ?

[fredericvillemi]

Hello,

I'm always amazed by the power of using QlikView through VB Macro but the lack of documentation and examples about it.

I'm trying to create a line chart with conditional expressions through VB (to quickly add 50 conditional expressions)

I'm able to remove all expressions

Set o = mydoc.GetSheetObject("CH349")

For i = 0 To o.GetProperties.Expressions.Count - 1

    o.RemoveExpression (0)

Next

Then I add all expressions and change a Comment

myLine = 1

While Cells(myLine, 4) <> ""

    cond = Cells(myLine, 4)

    myExpr = Cells(myLine, 19)

    o.AddExpression (myExpr)

    Set pq = o.GetProperties

    Set expr = pq.Expressions.Item(myLine - 1).Item(0).Data.ExpressionData

    expr.Comment = "test"

    o.SetProperties pq

    myLine = myLine + 1

Wend

But now I would like to change the Caption of these Expressions AND to add a conditional expression for each of them

how can I do ?

Thanks