So Excel has the facility to open workbooks whenever the excel.exe open! How? So my friend's main query is, sometimes he may forget to open an excel file and thus he will not get notified and so on. So How can we automate that, so I don't have to think about that workbook anymore?Īnswer: We can create multiple complicated solutions where many external application and windows API solutions will integrate with Excel services and you will be notified. Even we can use Outlook reminders but sometimes, people don't seem to use Outlook so we have to deliver here some general solution which can be applicable to all windows users. But he added that Kamal, sometimes I forgot to open that Employee workbook due to busy schedule and I would miss few operations I had to drive after seeing the dashboard. As soon as he opens the Employee workbook, VBA will sort all the employee's data and keep visible only data which is important to know by him today. Query: My friend wants Excel to notify him of his employees' project completion date, one month, or one week in advance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |