Pop-up Alerts

[andyb16]

Hi All,

I have a simple tabulated data as shown below:

<table width="229" border="0" cellpadding="0" cellspacing="0"><col style="width: 81pt;" width="108"> <col style="width: 91pt;" width="121"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 81pt;" width="108" height="20">License Number</td> <td class="xl65" style="border-left: medium none; width: 91pt;" width="121">Renewal deadline</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">123</td> <td class="xl67" style="border-top: medium none; border-left: medium none;">30-Aug-11</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">456</td> <td class="xl67" style="border-top: medium none; border-left: medium none;">28-Jun-11</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; border-top: medium none;" height="20">789</td> <td class="xl67" style="border-top: medium none; border-left: medium none;">15-Nov-11</td> </tr> </tbody></table>
My aim here is that this excel workbook should auto-open one month before the "Renewal deadline" and the date should start flashing.

Is there any way that this could be done by employing functions and formulas.

OR is VBA the way to go?

If the answer is VBA then please could someone suggest a suitable code as VBA is not my forte?

Thanks a lot!

 

[wigi]

I would use simple conditional formatting to highlight the ones that are going to expire in one month's time. Should not be complicated. For auto-opening you indeed need VBA code and also (preferably) the Windows Scheduler.

 

[Glory]

Do you use Excel regularly?

You could make modifications to PERSONAL.xls.

Otherwise you're gonna need more than VBA.

Have you considered an alarm clock?

 

[andyb16]

@Glory: Yes, I do use excel regularly. How do I go about making these modification you mentioned?

@Wigi: Please could tell me more about the Windows Scheduler?

Thanks,
Andy

 

[wigi]

As the name tells you already, the Windows Scheduled Tasks allow you to e.g. run a file at dedicated moments. See http://www.iopus.com/guides/winscheduler.htm or other internet pages if you Google on the term. It's built-in in Windows.

 

[andyb16]

Thanks Wigi,

This is simple and makes sense to me now. I can work with this.

 

[wigi]

Good