S
Sean
Sorry I wanted to bump this one up, hoping someone can help
http://www.microsoft.com/office/com...01b12f-9cbf-404a-9418-5ed6e455f9a8&sloc=en-us
Basically I has an XML file that represents some data from a CSV file. I am
using XML because it has a "live" update capacity of sorts.
So I use "Data >> XML >> XML Source" or" Import"
This give me my data from the XML file in the XLS file. Which is great. Save
the XLS file and I have 2 files XML and XLS.
When the XML file changes I can use "Data >> XML >> Refresh XML Data" to get
the updated info.
The Problem is, when I take these 2 files to another computer, change the
info in the XML file and use "Data >> XML >> Refresh XML Data", I get an
error saying it can't find the data from C:\Blah\Blah\Blah\, the directory on
where I origionaly created the XML\XLS files.
I would like to know, is there any way in Excel to remove the full path to
the XML and use a relative path - in this case no path as both files are in
the same directory.
Thanks in advance - Sean.
http://www.microsoft.com/office/com...01b12f-9cbf-404a-9418-5ed6e455f9a8&sloc=en-us
Basically I has an XML file that represents some data from a CSV file. I am
using XML because it has a "live" update capacity of sorts.
So I use "Data >> XML >> XML Source" or" Import"
This give me my data from the XML file in the XLS file. Which is great. Save
the XLS file and I have 2 files XML and XLS.
When the XML file changes I can use "Data >> XML >> Refresh XML Data" to get
the updated info.
The Problem is, when I take these 2 files to another computer, change the
info in the XML file and use "Data >> XML >> Refresh XML Data", I get an
error saying it can't find the data from C:\Blah\Blah\Blah\, the directory on
where I origionaly created the XML\XLS files.
I would like to know, is there any way in Excel to remove the full path to
the XML and use a relative path - in this case no path as both files are in
the same directory.
Thanks in advance - Sean.