• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Task management pop-up even the file is closed

sudipto3003

Member
dear all,


now i am going to make a file where i have received post dated cheques for various purpose, what i need a pop-up at the particular "deposit date" at 10:00am, if the pop-up comes even my file is not open it will be more helpfull for me. is it possible to make a desktop alert like outlook? i can do it through outlook but actually i required some details against each cheque. please help me.


https://www.dropbox.com/s/tahpi4xmjb8oj1s/TASK%20MANAGEMENT.xlsx?m


with thanks,

sudipta
 
You can use Windows Scheduler

Goto Start

All Programs

Accessories

System Tools

Task Scheduler


You will need to open the file using a line like

C:program FilesMicrosoft OfficeOffice10EXCEL.EXE "C:tempTask Management.xlsm"

Change path/file name to suit your needs


Then in Task Management.xlsm

you'll need to add some code to do what you want to do in your file

You will need to save it as a *.xlsm file as it contains macro's
 
Back
Top