M
Mark W. Robbins
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their reporting spreadsheet, I need to be able to specify a
relative path (i.e.: the same folder where the spreadsheet is stored) for the
XML data file.
Unfortunately, Excel *always* inserts a full path when selecting a data
file. I cannot find any option that allows me to specify a generic relative
path.
Can anybody help?
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their reporting spreadsheet, I need to be able to specify a
relative path (i.e.: the same folder where the spreadsheet is stored) for the
XML data file.
Unfortunately, Excel *always* inserts a full path when selecting a data
file. I cannot find any option that allows me to specify a generic relative
path.
Can anybody help?