Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default i want to put a date into excel and then on that date be alerted

I am putting together a maintenance schedule worksheet on excel. As part of
this i wish to input future dates at which maintenance is required to be
performed. The excel document will be a live document. Is it possible that,
on the dates in question, i am alerted of the required maintenance with a
message or alarm, potentially through oulook or any other programme. i.e. is
there away that the date in the excel data box can be linked to an alert
function?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default i want to put a date into excel and then on that date be alerted

I'm not sure if this is what you had in mind, but look at area #3 on this web
page:
http://www.microsoft.com/atwork/getw...treamline.mspx
tells how to set up Outlook tasks while you are in Excel.

Another way would be to set up some code in the Excel workbook, probably in
the Workbook_Open() or Worksheet_Activate() event that would look through the
list of dates on a particular sheet and toss up a message to you when a date
was 'today'. You'd have to open the workbook each day to get the alerts.

"craign27" wrote:

I am putting together a maintenance schedule worksheet on excel. As part of
this i wish to input future dates at which maintenance is required to be
performed. The excel document will be a live document. Is it possible that,
on the dates in question, i am alerted of the required maintenance with a
message or alarm, potentially through oulook or any other programme. i.e. is
there away that the date in the excel data box can be linked to an alert
function?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Date - Date Recv = Days Late, but how to rid completed date MS Questionnairess Excel Worksheet Functions 1 January 24th 07 11:05 PM
Excel Formula to calulate number of days passed from date to date K. Mack Excel Discussion (Misc queries) 8 January 4th 07 11:27 PM
Make date change in excel to current date when opening daily? jamie Excel Discussion (Misc queries) 3 March 1st 06 03:37 PM
Date stamp spreadsheet in excel to remind me of completion date Big fella Excel Worksheet Functions 1 October 18th 05 04:10 PM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"