Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 4th, 2005, 03:46 AM
Friend of Wrox
Points: 7,425, Level: 36
Points: 7,425, Level: 36 Points: 7,425, Level: 36 Points: 7,425, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,524
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
Reply With Quote
  #2 (permalink)  
Old May 4th, 2005, 03:49 AM
Friend of Wrox
Points: 7,425, Level: 36
Points: 7,425, Level: 36 Points: 7,425, Level: 36 Points: 7,425, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,524
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
Reply With Quote
  #3 (permalink)  
Old May 4th, 2005, 04:43 AM
Friend of Wrox
Points: 7,425, Level: 36
Points: 7,425, Level: 36 Points: 7,425, Level: 36 Points: 7,425, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Mauchline, East Ayrshire, Scotland
Posts: 1,524
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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Invalid Character in the given encoding mswin XSLT 3 November 28th, 2008 05: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



All times are GMT -4. The time now is 07:15 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.