Excel 2003 & xml-file: change referring path of input file?

J

Jannick Asmus

Hi,

I would like to change the path of input data of an xml-file coded below
without editing the xml-file. The best would be that it could be changed
somewhere in the Excel window.

<udc:DataSource MajorVersion="1" MinorVersion="0"
xmlns:udc="http://schemas.microsoft.com/data/udc">
<udc:Type Type="XMLFile" MajorVersion="1" MinorVersion="0"/>
<udc:Name>Binding1</udc:Name>
<udc:ConnectionInfo Purpose="Query">
<udcxf:File
xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile">
C:\input.xml
</udcxf:File>
</udc:ConnectionInfo>
</udc:DataSource>


I am Excel2003 user.

Thank you.

Best wishes,
J.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HTTP Basic authentication with UDC - Infopath 0
XML - VBA conversion (.uxdc file) 0
"Unspecified Error" when loading an XML spread sheet with XML Maps 1
Preserve XML whitespace in Excel 2003 0
Relative file path for XML data... 0
How to change the row1 content of the existing excel file automically 2
VBS script to add xml data to excel 0
Search for name of a file in a directory (http path) 3

Top