Set Variable to a Formula via Action

[#1]

I am trying to set a variable to a formula (i.e., beginning with an equal sign) via an action trigger.

I was able to successfully set a variable to call the =OSUser function by setting the action to assign its value as ='=OSUser()'

However, I can't seem to make this "style" of a formula setting work if the formula itself has quotes in it.

Example:

='=''test'''

Any suggestions???

[pover · Accepted solution]

Use chr(34) like the following:

='='&chr(34)&'test'&chr(34)

Regards,

[#3]

Thank you very much. FYI, I needed to use chr(39) instead of 34 but it worked great!!!