variable with commas and quotes

[Barrett Bonden]

how to create a variable with embedded commas and quotes ?
when I try something like t1= " "test", "test" " it blows up ....

 

[Wayne Morgan]

Try

t1 = " ""test"", ""test"" "
Debug.Print t1

Since quotes are the delimiter, when VBA sees the next quote it thinks it is
the next delimiter. If you double them up, it knows to treat them as a
literal quote to be inserted into the string. The result from above would
be:

"test", "test"

Of course, the leading and trailing spaces are hard to see here.

 

[Guest]

Or
t1 = chr(34) & "test" & chr(34)

Try

t1 = " ""test"", ""test"" "
Debug.Print t1

Since quotes are the delimiter, when VBA sees the next quote it thinks it is
the next delimiter. If you double them up, it knows to treat them as a
literal quote to be inserted into the string. The result from above would
be:

"test", "test"

Of course, the leading and trailing spaces are hard to see here.