Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule downloads
I have a macro, "GetQuotes", that downloads some market data. I need to run
the Get Quotes macro every 10 minutes from 6PM Sun to 5PM Fri. RBS gave the following reply: Simplest is to use the Windows task scheduler. This can start Excel with a workbook as an argument to open that workbook. Code can then be started from the Workbook_Open event and your code can then detect the end of Friday to stop running and close the workbook and then do an Application.Quit. Does that mean have Windows Task Scheduler start Excel every 10 minutes, and it will open a certain workbook each time an instance of Excel is launched? I'd much rather run the schedule in VBA if that is possible. Is there capability in VBA for timing events in this way? Thanks, Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule downloads
As stated in your other post..................
This will get you most of the way the http://www.cpearson.com/excel/OnTime.aspx Insert your code in the appropriate place and you should be in business. Regards, Ryan-- -- RyGuy "Andyjim" wrote: I have a macro, "GetQuotes", that downloads some market data. I need to run the Get Quotes macro every 10 minutes from 6PM Sun to 5PM Fri. RBS gave the following reply: Simplest is to use the Windows task scheduler. This can start Excel with a workbook as an argument to open that workbook. Code can then be started from the Workbook_Open event and your code can then detect the end of Friday to stop running and close the workbook and then do an Application.Quit. Does that mean have Windows Task Scheduler start Excel every 10 minutes, and it will open a certain workbook each time an instance of Excel is launched? I'd much rather run the schedule in VBA if that is possible. Is there capability in VBA for timing events in this way? Thanks, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template downloads | New Users to Excel | |||
Schedule downloads | Excel Programming | |||
Macro to schedule downloads | Excel Programming | |||
File Downloads in VBA | Excel Discussion (Misc queries) |