Create a schedule Task in excel

[vijay.vizzu]

Dear All,


I just want to know that, can we create a schedule task in excel, like in certain date/time, selected files to be open, run the macro in that file, close that file and again open a file doing same thing, After completing the task in a folder, it should open the another selected file, and run macro in that file and sending mails to selected email address.


Can we create a task like above

 

[DaveTurton]

It is possible. I would suggest looking at the following:


http://chandoo.org/forums/topic/vbs-problem-auto-running-vba-macro


http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/