Hi,

Thanks for all your ultimate support my previous posts.

I am facing difficulty in writing a code for birthday reminders employees based on their status of employment. in detail

Query:
In sheet1 column “A” contains employee names, column B contains DOB’s of employees, and column “C” (working, Resigned)contains the status of the employment, I would like to write a program in VBA to start reminding me about the employee birthdays in advance of two days along with the names if employee status is “working” , else reminder is not required.

I request any one of you to help me in writing this code, so that I don’t miss any of reminders


Regards
GV Reddy

Hi

You can write a small code and use Application.OnTime to fire the macro at regular interval. Say every day @ 7:00 am etc

The drawback here is the workbook/addin in which you write the code should be open.

The other option would be to write a small executable using VB6.0 etc and load them in Windows scheduler. The VB6.0 exe can read the Excel and prompt a message etc

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)