Forum Discussion
- MCFNeilQrew CaptainTry making any of these adjustments to your variable definitions.
http://stackoverflow.com/questions/19399610/passing-a-parameter-to-function-with-single-quote
I pass a variable of Current User to a javascript page. It works fine unless the name includes an apostrophe (O'Neil).
The formula includes: "var Cuser = '" & URLEncode(User()) & "';" &
How would I change this to not error out if name includes an apostrophe?
BTW the error if user name has an apostrophe is : SCRIPT1004: Expected ';'
Thanks