Calculating Hyperlinks

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
Fri Apr 25 14:23:36 PDT 2008

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:
dailytips-subscribe-request@lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM



"expect_ed" <expected@discussions.microsoft.com> wrote in message
news:408B8567-F465-4153-84BE-27550CA15E6D@microsoft.com...
> 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

expected
Sun Apr 27 17:39:00 PDT 2008

What is whs??

"Diane Poremsky {MVP}" wrote:

> 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:
> dailytips-subscribe-request@lists.outlooktips.net
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
>
>
> "expect_ed" <expected@discussions.microsoft.com> wrote in message
> news:408B8567-F465-4153-84BE-27550CA15E6D@microsoft.com...
> > 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
Sun Apr 27 18:28:10 PDT 2008

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

--
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:
dailytips-subscribe-request@lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM



"expect_ed" <expected@discussions.microsoft.com> wrote in message
news:3555D803-EA6D-4ADC-87BF-26AB122CE2F5@microsoft.com...
> What is whs??
>
> "Diane Poremsky {MVP}" wrote:
>
>> 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:
>> dailytips-subscribe-request@lists.outlooktips.net
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> Subscribe to Exchange Messaging Outlook newsletter:
>> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>>
>>
>>
>> "expect_ed" <expected@discussions.microsoft.com> wrote in message
>> news:408B8567-F465-4153-84BE-27550CA15E6D@microsoft.com...
>> > 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
>>