Relative file path for XML data...

[Vijay]

Hi,
I have imported XML data into a worksheet. When I change the raw xml
file and refresh the Excel sheet, everything works fine.

However, Excel seems to bind to the absolute path name of the source
xml file (Ex. E:\My Documents\Default Data\data.xml). I would like to
use relative paths instead, because I need to add this excel sheet
into source control and other users may not have the same path as me.

Any ideas on how I can do this?

Thanks!
Vijay