Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
URL forwarding in Excel?
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
URL forwarding in Excel?
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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
URL forwarding in Excel?
"David Biddulph" wrote 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: Thanks for the response David. It's greatly appreciated. Sadly that solution didn't work when I tried to launch the html page in Excel (as I need to in this case), although it did work if I launched the page in a web browser. Here's the code I used: <HEAD <META http-equiv="REFRESH" content="5; URL=http://www.mywebspace.com/data.csv" <pRedirecting to <a href="http://www.mywebspace.com/data.csv"data.csv</a</p] Perhaps I'm doing it wrong though. I'm a beginner at this kind of thing Best T |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
URL forwarding in Excel?
I should add it almost works. It brings up a link in Excel which if clicked
upon has the desired effect. If this link were to autolaunch I'd be there I think. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |