Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Date stamp spreadsheet in excel to remind me of completion date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |