Display double quotes in text.

[Vamsi.]

Hi,

I am writing a Macro in Excel2003.
I have a variable x.

x = "ABC"

I want to dispay the text

Hello r u fine "ABC"

Note that ABC must be in double quotes.

When i give the following command i am getting error:

Hello r u fine & """ & x & """ --This doesn't work for
double quotes

Hello r u fine & "'" & x & "'" --This works for
displaying single quotes

Why is this so!!! how do i go about this??

Appreciate any help.

Vamsi.

 

[Frank Kabel]

Hi
one way:
str = "Hello r u fine" & chr(34) & x & chr(34)

 

[Rob van Gelder]

Whenever you want to enclose " in doublequotes, represent it as ""
x = "Hello r u fine ""ABC"""

or

x = "ABC"
MsgBox "Hello r u fine """ & x & """"


Please - do not use Chr(34) for this purpose - It's so nasty.

 

[Steve Garman]

Sub test()
Dim s$
s$ = "ABC"
MsgBox "Hello r u fine """ & s$ & """"
End Sub

 

[Frank Kabel]

Whenever you want to enclose " in doublequotes, represent it as ""
x = "Hello r u fine ""ABC"""

or

x = "ABC"
MsgBox "Hello r u fine """ & x & """"


Please - do not use Chr(34) for this purpose - It's so nasty.

Hi Rob
why do you think this is nasty
IMHO especially beginners could have problems with double quotes

Frank

 

[Rob van Gelder]

MsgBox Chr(84) & Chr(114) & Chr(117) & Chr(115) & Chr(116) & Chr(32) & _
Chr(109) & Chr(101) & Chr(44) & Chr(32) & _
Chr(105) & Chr(116) & Chr(39) & Chr(115) & Chr(32) & _
Chr(110) & Chr(97) & Chr(115) & Chr(116) & Chr(121)

For the beginner, learning escape character concept is far more useful than
learning the Ascii table.
Escape characters are used in many programs.

 

[Frank Kabel]

MsgBox Chr(84) & Chr(114) & Chr(117) & Chr(115) & Chr(116) & Chr(32)
& _ Chr(109) & Chr(101) & Chr(44) & Chr(32) & _
Chr(105) & Chr(116) & Chr(39) & Chr(115) & Chr(32) & _
Chr(110) & Chr(97) & Chr(115) & Chr(116) & Chr(121)

For the beginner, learning escape character concept is far more
useful than learning the Ascii table.
Escape characters are used in many programs.

o.k I'm convinced!

Frank

 

[Bob Phillips]

Please - do not use Chr(34) for this purpose - It's so nasty.

Sanity at last<G>. Well said Rob.

 

[Tanner Dhesi]

Hi - something along these lines should work - just need
more double quotes!

"Hello r u fine """"" & x & """"""

Tanner Dhesi
(e-mail address removed)

 

[Dana DeLouis]

I have seen some code that split the difference and written like this:

Dim s As String
Dim qq As String 'Double Quote
qq = Chr(34)
s = "Hello r u fine " & qq & "ABC" & qq
MsgBox s

I personally find this way a little easier to read and debug. To me, it is
a hair clearer that qq is in fact the Double Quote character.

One can also use characters a little higher on the asc chart if one's
situation allows.
Here, I often might use the double quotes from the Alt+0148 character.
(I don't think it will show here in the newsgroup posting).

s = "Hello r u fine "ABC" "

On a really complicated string about to be evaluated, I just cannot follow /
debug the many double quotes. By using 148, I find it much easier to read.
I will then run a final cleanup before evaluation by letting Excel do the
hard work.

s = Replace(s, Chr(148), Chr(34))


Just some thoughts. :>)

 

[pmarino]

QuoteQuote is understood as a quote mark within a string

So your code should be

Hello r u fine & """" & x & """"

that's four quote marks 1) open quote 2,3) quote inside a string 4
close quot