Subject: RE: [xsl] Programatically Generate Well-Formed XML with .NET From: "Houghton,Andrew" <houghtoa@xxxxxxxx> Date: Fri, 27 Jun 2008 12:27:55 -0400 |
> From: Ronnie Royston [mailto:rhroyston@xxxxxxxxx] > Sent: Friday, June 27, 2008 12:22 PM > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: [xsl] Programatically Generate Well-Formed XML with .NET > > I'm using VBA to write a file with a .xml extension on to my > harddrive. Basically, I'm using the Range.Text method in Excel VBA as > the selector and a stream output method to write out a text file. The > problem is that it is not consistently writing well-formed XML. After > running my crummy program, a browser often chokes on the result with > > "Whitespace is not allowed at this location. Error processing resource > 'file:///C:/Saxon/bin/mySkus.xml'. Line 58, Position..." > > here is a copy/paste of my line 58. > <sku quantity="1" description="XMediusFAX Express Server 50 Users & 2 > Channels *Server Supplied by Benchmark">XM-EXP-50</sku> You need to quote &, <, and > in your VBA code before writing it out: string = VBA.replace(string,"&","&"); ' Needs to be done first. string = VBA.replace(string,"<","<"); string = VBA.replace(string,">",">"); Andy.
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Programatically Generate Well, Ronnie Royston | Thread | Re: [xsl] Programatically Generate , James A. Robinson |
Re: [xsl] LINQ to XML versus XSLT, Colin Paul Adams | Date | Re: [xsl] Programatically Generate , James A. Robinson |
Month |