Daily Automatically Updating Hyperlinks ...

[Avel]

Hey Guys,

I'm terrible at explaining things so here goes.

I work in logistics, and in an office of about 30 staff with new staff members coming and going all the time. We work off about 15 different drives and access a range of about 300 different spreadsheet everyday, all located in files on these drives all in different locations.

Now these file locations never change, but for the day we create new excel spreadsheets to work off. These file names are exactly the same everyday ... For instance.

For the 13th of September 2007 one will be called ...
C13.09.2007

Then on the 14th of September 2007 a new file, serving the same purpose for another day will be created called ...
c14.09.2007

Now, we have a book about 30 pages long listing the location of all these files and as I'm sure you can imagine is very time consuming to look through.

I was wondering if it would be possible to make a a website ... On our local intranet that automatically updates all these to the current days spreadsheet? So one can just click a link, and it automatically goes to the daily spreadsheet without any manual changing?

The actual folder the file is located in never changed, it's just a new excel spreadsheet that is created on a daily basis using the same forumla as used on all the spreadsheet before (As explained above)

Thanks so much for your help...

Avel.

[TheBearMay]

Simple javascript:


function setName(){
var tday=new Date();
var tdayy=tday.getFullYear();
var tdaym=tday.getMonth();
var tdayd=tday.getDate();
return "C"+tdayd+"."+tdaym+"."+tdayy;
}

<a href="#" onclick="window.location=setName()">Excel File</a>