I have been trying to write a macro that will update the user variables in the parameters manager. Since there is no direct method to do this in the API, I am attempting to do it with the dsApp.RunCommand method. However, I can't seem to find how I can pass a string variable to this command and the documentation that I've searched doesn't provide a good syntax definition of the dsRunCommand method.
This is the code:
Dim update_var As String
Dim update_value As String
update_var = Worksheets("Sheet1").Range("A3").Value
update_value = Worksheets("Sheet1").Range("B3").Value
Dim state As Long
state = dsApp.RunCommand("-PARAMETERS EDIT update_var" & Chr(10), "update_value" & Chr(10), False)
Any insight on how to accomplish this would be much appreciated.
KS
