Hi,
I am trying to calculate values in VBA. The following code should get value from "A" variable and calculate for variable "B" = ( A + 10). Some how it is not working. Can you please help me?
Thanks,
Dave
Sub Try()
Dim strYearVals As String
Dim bodvrYear As DocumentVariable
Set bodvrYear = ThisDocument.DocumentVariables("Sigma"
For i = 1 To UBound(bodvrYear.Values(BoAllValues))
ThisDocument.DocumentVariables("trySigma"
.Values(BoAllValues)(i) = (bodvrYear.Values(BoAllValues)(i) + 10)
Next i
ActiveReport.ForceCompute
End Sub
I am trying to calculate values in VBA. The following code should get value from "A" variable and calculate for variable "B" = ( A + 10). Some how it is not working. Can you please help me?
Thanks,
Dave
Sub Try()
Dim strYearVals As String
Dim bodvrYear As DocumentVariable
Set bodvrYear = ThisDocument.DocumentVariables("Sigma"
For i = 1 To UBound(bodvrYear.Values(BoAllValues))
ThisDocument.DocumentVariables("trySigma"
Next i
ActiveReport.ForceCompute
End Sub