How to use double quotes in a text ?

[origami]

Hi all,

I've got a quick and easy question :
How to use double quotes in a string ?

I tried the usual stuff (using backslash; using 2 doubles quotes), but it does not seems to be that.

Thank you very much for your help.

And congratulations to the developers for this great software !

[Erel]

You should use chr(34):

"This is a " & chr(34) & "double quote" & chr(34)
Or:
q = chr(34)
"This is a " & q & "double quote" & q

[origami]

Thanks for your quick answer !

[badkarma]

Hello Origami and welcome !

If you are doing hoardes of quotes in strings, and want some tidy readable code ...

' function to change apostrophe to quote
sub a2q(mystr)
a2q = strreplace (mystr," ' ", chr(34)) ' spaces for clarity of apostrophe
end sub

...

x = a2q("Hello 'World', this is your 'infamous' captain 'Jack Sparrow' speaking!")
y = a2q("Arrgh! So 'you' be that 'scurvy knave' they call 'captain jack?' ")
z = a2q("'Aye!' I be that 'scurvy knave' ... ")

Of course if you are using apostrophes as well, then simply use the reverse apostrophe ... ` ... normally found at the top left of your keyboard, like this...

' function to change rvs apostrophe to quote
sub a2q(mystr)
a2q = strreplace (mystr,"`", chr(34))
end sub

...

x = a2q("Hello `World`, this is your `infamous` captain `Jack Sparrow` speaking!")
y = a2q("Arrgh! So `you` be that `scurvy knave` they call `captain jack?` ")
z = a2q("`Aye!` I be that `scurvy knave` ... ")