View Single Post
  #2  
Old April 25th 08, 11:23 PM posted to microsoft.public.outlook.calendaring
Diane Poremsky {MVP}
external usenet poster
 
Posts: 1,260
Default Calculating Hyperlinks

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 - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:




"expect_ed" wrote in message
...
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


Ads