Calculating Hyperlinks

  • Thread starter Thread starter expect_ed
  • Start date Start date
E

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
 
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.
 
What is whs??

Diane Poremsky {MVP} said:
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.
 
Back
Top