Solved Can Excel do auto task.

October 20, 2016 at 00:38:30
Specs: Windows 10
I have a sheet that have auto updated prices from the net. can I set a task to action at certain times of the day so it copies the data from one form lets say at 10:00pm daily it grabs the data from form1 cell a1 and pastes it to form2 cell a1 then the next day it grabs the data from form1 cell a1 and pastes it to form1 cell a2.

See More: Can Excel do auto task.

Report •

#1
October 21, 2016 at 12:44:33
✔ Best Answer
This can be done by using the OnTime method in VBA.

It's easier if the workbook is open so that Excel does it by itself, otherwise I think you need to use some OS Scripting or the Windows Task Scheduler to open the file first.

A Google search for anything like this will return lots of hits:

run excel macro automatically OnTime

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question