Hey Guys,
I'm looking for code that will allow me to set up a Task Scheduler that will open my excel file, wait about 10 seconds for the data to refresh (the data automatically refreshes upon open), send out email as an attachment, and then save and close it self.
I believe the task scheduler will open the file for me when scheduled and the data will refresh on its own.... I'm thinking the code I need is to wait for the refresh to finish and then send the email as an attachment, save and close.....
P.S. The above should only work when the task scheduler opens the file - i.e. when the file is sent out, I dont want the people receiving the file opening it up and then the process happens again
Thanks,
Zeke
I'm looking for code that will allow me to set up a Task Scheduler that will open my excel file, wait about 10 seconds for the data to refresh (the data automatically refreshes upon open), send out email as an attachment, and then save and close it self.
I believe the task scheduler will open the file for me when scheduled and the data will refresh on its own.... I'm thinking the code I need is to wait for the refresh to finish and then send the email as an attachment, save and close.....
P.S. The above should only work when the task scheduler opens the file - i.e. when the file is sent out, I dont want the people receiving the file opening it up and then the process happens again
Thanks,
Zeke
Last edited: