string needs double quotationmarks VBA now confused to which quotationmarks are what

Question

I need to append a string to a text file which has double quotation marks throughout it. How do I do that cause VBA is very confused at the moment

What the string should say/append the text file to (load "c:\test.lsp")?

Please don't scream. Also, starting your question with `LOL` might not be the best way to attract answers. — Frédéric Hamidi, Nov 01 '10 at 14:47
VBA is very confused at the moment? I'm very confused at the moment... — Brad, Nov 01 '10 at 14:50
Ironically, the only thing not capitalised is the first pronoun "i", which should be! — eldarerathis, Nov 01 '10 at 14:50
Maybe his capslock is permanently stuck on. See "vba" in the title. :-D — Brad, Nov 01 '10 at 14:52
Looks like the downvotes were mostly for format (and, as such, deserved to some extent). The problem seems to have been resolved on edit, whether by the OP or otherwise, so I've upvoted to offset. — RolandTumble, Nov 01 '10 at 17:00

score 6 · Answer 1 · answered Nov 01 '10 at 14:55

6

You can double the quotation marks inside the string:

"""The Professional"" is a killer movie."

Or use Chr(34):

Chr(34) & "The Professional" & Chr(34) & " is a killer movie."

answered Nov 01 '10 at 14:55

Frédéric Hamidi

THANKS FOR YOU INPUT MAGNUS HOFF (perhaps a hobby other then dogmatic would be nice) so the name playcat sounds like cat house – maple Nov 01 '10 at 15:03
Ahhh "cat house" ... of course – Dr. belisarius Nov 01 '10 at 15:30

1 Answers1