Hi,

New to excel programming. Is there a way to use xml config files (such as
in asp or java) to specify things like connection strings and file paths?

We move our excel application from test to production and need to point to
files in the correct path. Currently we have to go through and manually
search and replace path names. I would like to handle this in a config file
where the excel workbook reads this and would know whether to point to test
or production.

We could either have separate config files for test and production or an xml
with nodes specifically for test or production. Any ideas?