View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Putting Quotes in for XML

To include double quotes, double them:

strXML = "<FORM Name=""XXX"""


In article ,
"Rone" wrote:

I'm trying to build an XML file using VBA. I want to put something like this
in a string variable: <FORM Name="Rones Form"</FORM

The problem I'm having is with the quotes. Because its already in a string (
strXML = "<FORM Name=XXX") when I put the quotes in where the name of the
form gose it fails. In Unix Shell I could place an escape character which
would allow me to do stuff like this. Anyone got any ideas how to do this in
VB?