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