How to insert: " into a string
 

Hi

How do I insert a: " into a VBA string?

Thanks
Torben Laursen



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004

How to insert: " into a string
 

double the double quotes:

"this string ""contains"" double quotes"

from the immediate window (to illustrate):

sStr = "this string ""contains"" double quotes"
? sStr
this string "contains" double quotes

--
Regards,
Tom Ogilvy

"Torben Laursen" wrote in message
...
Hi

How do I insert a: " into a VBA string?

Thanks
Torben Laursen



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004

How to insert: " into a string
 

If I understand the question correctly, I believe it is done with two
quotation marks when inside a "string."

[A1].Formula = "=CONCATENATE(""First "",""Second"")"

HTH
--
Dana DeLouis
Win XP & Office 2003


"Torben Laursen" wrote in message
...
Hi

How do I insert a: " into a VBA string?

Thanks
Torben Laursen



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004

How to insert: " into a string
 

Hi Tom and Dana

Thanks but I must be very slow <g
What I want is to insert quotes around the string FileName in the code
below;
I don't see how I can do that using double quotes

FileName = Application.GetOpenFilename("VLXE Files (*.XML), *.XML")
If FileName < False Then
str = "=VLXE_WriteFileIntoDll(" & FileName & ")"
ActiveCell.Offset(rowOffset:=0, columnOffset:=0).Value = str
end if

Thanks
Torben Laursen



How do I insert a: " into a VBA string?

Thanks
Torben Laursen



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004