Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel 2003 "file error: data may have been lost" after applying SP3 | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
excel 2003 "french "always reloads with error message when closin | Excel Discussion (Misc queries) | |||
How do I correct Runtime error "53" in excel 2003 | Excel Discussion (Misc queries) |