All geek questions in one place

How can I run Excel files as a task or task?

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

I have a file that I created that is updated from data. I use a cell as a parameter to populate the data feed. I want to see if there is a way to configure the task to start and save automatically. If possible, save them in a cell in Excel.

Any thoughts?

+4
source share
2 answers

Use Windows Scheduler to schedule a task to open an Excel file. Then you can use the Workbook_Open event to perform the necessary actions on the file.

+6
source

As Danny and Adil B noted, you can use Windows Scheduler to schedule events. But I usually plan to run a vbs script to control Excel, and not to open Excel directly - this method provides more control over macro security settings if this is a problem

See this example for vbs scheduling with Windows Scheduler

How does your data feed work and do you need help with this part?

+4
source

Source: https://habr.com/ru/post/1381978/

More articles:


All Articles