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.

--
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

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:


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

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:


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
...
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:


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