Calculating Hyperlinks

[expect_ed]

I need to review a status report weekly which is stored deep in
sub-directories on a mapped network drive. I have a recurring appt. set to
remind me to review the report and would like to add a link to the appt. that
opens the buried file. Unfortunately the file is named by date and is
updated weekly (on Friday). I know I can add a link to the appointment when
the file has a constant name, like this:

<file://R:\Status Reports\2008\April\UUS Div\GL group\Status-04-25-08.xls>

is there a way to create a similar link but to calculate the last portion so
that it picks the file with the date of the most recent Friday?

Thanks in advance for any help.

Ed

 

[Diane Poremsky {MVP}]

you might be able to do something with VBA in a custom form. I'd probably so
it with a whs and Windows Task Scheduler.

 

[expect_ed]

What is whs??

you might be able to do something with VBA in a custom form. I'd probably so
it with a whs and Windows Task Scheduler.

 

[Diane Poremsky {MVP}]

a typo. WSH. windows scripting service - a new age BAT.