If you pointed your link from Excel, not directly to data.csv, but to an
html page, say data.htm, then in that html page you could include in the
<HEAD section the line:
<META http-equiv="REFRESH" content="5;
URL=http://www.mywebspace.com/data.csv"
[and preferably in the body include something like:
<pRedirecting to <a
href="http://www.mywebspace.com/data.csv"data.csv</a</p]
.... and then you can change that redirection within the html file on your
server.
--
David Biddulph
"tishoo" wrote in message
...
Hello - might I ask for the assembled wisdom of the group.
I have an Excel spreadsheet that automaticaly opens
www.mywebspace.com/data.csv in Excel when I open the spreadsheet. I want
to send this spreadsheet out to others, and then from time to time change
the destination away from www.myspace.com simply by altering the file on
my server to forward to data.csv at another location and open that fiile
instead. I won't be able to change the spreadsheet itself once it's been
distributed.
In other words I want to do a URL redirect using Excel.
How do I alter my spreadsheet to make this possible?
If anyone know the answer I'd be most grateful. I'm using Office 2003
Best
T