I wrote an SQL file and embedded it into an excel spreadsheet. It does refresh when opened. Now my employer wants to email this report to some other people. My question is:
1. Is there a scripting language which will open the Excel Spreadsheet and allow it refresh?
2. Close and save the sheet
3. Mail the report to a list of emails.
4. Do this at what time I want.
5. Do this without any employee intervention.
Right now, I have a coworker who does this, but they tend to forget. Any thoughts on how to do this? What tools to research?
Thank you,
Michael