How can I Run Excel Files as a task or job? [closed]

Question

Is it possible to schedule an Excel file to run on a certain day?

I have a file I built that is refreshed from data. I use a cell as the parameter to populate the data feed. I want to see if there is a way to setup a job to run these automatically and save them. If possible save them by a cell in Excel.

Any thoughts?

Answer 1

Use the Windows Scheduler to schedule a task to open up the Excel file. You should then be able to use the Workbook_Open Event to do what you need with the file.