Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 4th, 2005, 03:46 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default An invalid character was found in text content

I am getting this error in MSIE:

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


An invalid character was found in text content. Error processing resource 'file:///C:/Inetpub/wwwroot/Fares/XML_files/Fares...

has been made and no change fee is applicable.&lt;/td&gt;&lt;/tr&gt;</content></fare_rule_lines>...

Can anyone see what is wrong with my code below:

this is when i right-click and 'edit' the file. i get this output in Notepad...

Code:
<content>&lt;table&gt;&lt;tr&gt;&lt;td&gt;Exception&lt;/td&gt;&lt;td&gt;Paper tickets&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;boarding if a ticket is revalidated  by the agent.&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Schedule Changes&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;The only exception to the revalidation rule above will be in the case of schedule changes.  Where action is taken by&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;the agent to revalidate, the ticket coupon must be marked sked change&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;E tickets&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;has been made and no change fee is applicable.&lt;/td&gt;&lt;/tr&gt;</content>
www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt
__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk
 
Old May 4th, 2005, 03:49 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

this is the code when i change it to HTML table format:
Code:
<table>
<tr><td>Exception</td><td>Paper tickets</td></tr>
<tr><td>boarding if a ticket is revalidated  by the agent.</td></tr>
<tr><td>Schedule Changes</td></tr>
<tr><td>The only exception to the revalidation rule above will be in the case of schedule changes.  Where action is taken by</td></tr>
<tr><td>the agent to revalidate, the ticket coupon must be marked sked change</td></tr>
<tr><td>E tickets</td></tr>
<tr><td>has been made and no change fee is applicable.</td></tr>
</table>
what cant the XML handle?

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt
 
Old May 4th, 2005, 04:43 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default

The fix;

--------------------------------
XML document must start with:

<?xml version='1.0' encoding='iso-8859-1' ?>

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt





Similar Threads
Thread Thread Starter Forum Replies Last Post
Invalid Character in the given encoding mswin XSLT 3 November 28th, 2008 06:01 AM
ORA-00911: invalid character cpajoe2001 Oracle ASP 2 August 18th, 2008 06:52 AM
content hash found in signed attributes different Dexray BOOK: Beginning Cryptography with Java 1 April 9th, 2008 03:49 PM
% is an invalid character? owoade .NET Web Services 1 August 12th, 2007 12:32 PM
JSP: Count character in text file life4fun7 JSP Basics 1 June 7th, 2006 09:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.