Putting Quotes in for XML

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Nevermind...I fout that the following will work: strQuote = """". This displays a ", which is what I needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newline character in XML cell reference when creating xlsx from XMLzipped files 1
Preserve XML whitespace in Excel 2003 0
XML API in VBA under Excel? 1
Special Character inside XML string data 4
Treeview - XML editor in VBA 0
Excel 2003 VBA string literal help location 9
How to do double quotes in "cell language"? 4
Testing xml string is well formed xml 2

Back
Top