Using a cell reference in a connection string

S

Simon

Hi all

I am using excel as a frontend reporting tool to display some performance
data that is held in a sql database. This spreadsheet and the database
behind it will be altered over time as we incorporate new data into it. I
will be doing these changes on our test environment first before moving it
to live. Because i will be altering the test version of the spreadsheet i
dont want to have to redo the same changes to the live one instead i would
just like to change the server in the sql connection string.

The way i have been doing this up until now is to save the spreadsheet as an
xml file and then do a search and replace on the connection string.
Unfortunately the spreadsheet includes quite a few graphs which are removed
when it is converted to xml so i am in a bit of a no win situation.

I read a post in this newsgroup explaining how to use the value of one of
the cells to alter the database the connection string points to but i cannot
get this working for me. Is this possible and am i going about changing the
connection string in the best way?

Many thanks in advance

Simon
 
Top