Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 1
Default "XML parse error" in Excel 2003

Hello,

I'm trying to add an XML schema to an Excel 2003 workbook
using the following javascript:

<script language="JavaScript" type="text/javascript"
<!--
var xlApp;
xlApp = new ActiveXObject("Excel.Application");
xlApp.Visible = true;
xlApp.Workbooks.Add();
xlApp.Workbooks(1).XmlMaps.Add("C:\Documents and
Settings\My Documents\Office 2003\order1.xsd");
//--
</script

the last line prompts an error message "XML Parse error"
in the Internet Explorer. The file however does not seem
to be a problem at all, as when I'm manually adding the
same XSD file to Excel (via Data-XML-XML source XML
Maps..) there is absolutely no problem with the file.
An example of such a file which is a stripped down version
of Microsoft's own example from the "Using Excel 2003
Object Model to Add XML Data Integration" article is:

<?xml version="1.0" encoding="ISO-8859-1" ?
<xs:schema
xmlns:xs="http://www.w3.org/2001/XMLSchema"<xs:element
name="test"
<xs:complexType
<xs:sequence
<xs:element name="orderperson" type="xs:string"/
<xs:element name="orderperson1" type="xs:string"/
</xs:sequence
<xs:attribute name="orderid" type="xs:string"
use="required"/
</xs:complexType
</xs:element
</xs:schema



Does anyone know what the problem might be?

Thanks,
Tim

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Excel 2003 "file error: data may have been lost" after applying SP3 [email protected] Excel Discussion (Misc queries) 2 November 28th 07 10:02 PM
In Excel 2003 is there a way to prevent "Save As" and "Print"? lucky2000 Excel Discussion (Misc queries) 3 April 26th 07 02:49 PM
excel 2003 "french "always reloads with error message when closin didid68 Excel Discussion (Misc queries) 0 March 3rd 06 07:58 AM
How do I correct Runtime error "53" in excel 2003 mendip04 Excel Discussion (Misc queries) 1 December 12th 05 10:22 PM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"