This content has been marked as final.
Show 4 replies
-
Re: Equations Update Fail.
Elmar Klammer Aug 25, 2016 5:18 PM (in response to Sanya Shmidt)'i believe chr(34) = "
swEqnMgr.Equation(ind) = "" & var & "=" + chr(34) + Values(0) + chr(34)
that should work if you looking for the missing "
-
Re: Equations Update Fail.
Sanya Shmidt Aug 26, 2016 9:45 AM (in response to Elmar Klammer)Elmar,
No, this one doesnt work. Same end result.
Thank you
-
-
Re: Equations Update Fail.
Ivana Kolin Aug 25, 2016 5:28 PM (in response to Sanya Shmidt)swEqnMgr.Equation(ind) = """" & var & """=" & Values(0)
-
Re: Equations Update Fail.
Sanya Shmidt Aug 26, 2016 9:45 AM (in response to Ivana Kolin)This one worked good! Thank you.
I also found another solution from Keith:
Dim vSplit As Object
vSplit = Split(swEqnMgr.Equation(ind), "=")
vSplit(0) = Replace(vSplit(0), Chr(34), "")
If vSplit(0) = var Then _
swEqnMgr.Equation(ind) = Replace(swEqnMgr.Equation(ind), vSplit(1), Values(0))
but I like this one better cause its just one line :
swEqnMgr.Equation(ind) = """" & var & """=" & Values(0)
Thank you.
-