Cannot assign string variable VBA [duplicate]

Question

I am getting Expected: end of statement error when trying to set my string variable (data). Below is the code, not sure why it is doing that

data = "{" & vbNewLine & ""First Word": {" & vbNewLine & ""Second Word": ["

Any idea? probably staring at me right in the face but no idea why it's doing this.

Robert Harvey · Accepted Answer · 2020-05-15 22:18:17Z

3

You need to escape every double quote inside each string by using two double quotes.

Something like this:

data = "{" & vbNewLine & """First Word"": {" & vbNewLine & """Second Word"": ["

answered May 15, 2020 at 22:18

Robert Harvey

182k48 gold badges349 silver badges516 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1