Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule downloads
I have a macro (GetQuotes) to download market quotes. Now I need to write a
macro to run the GetQuotes macro every 10 minutes from 6PM Sun to 5PM Fri. Don't know how to do that. [RBS posted 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.] I am not sure what the suggestion means. Does it mean have Windows Task Scheduler open Excel every 10 minutes? What I'd like is a macro that does the scheduling. Is that possible? And, how would I detect end of Friday? Thanks, Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Schedule downloads
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) to download market quotes. Now I need to write a macro to run the GetQuotes macro every 10 minutes from 6PM Sun to 5PM Fri. Don't know how to do that. [RBS posted 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.] I am not sure what the suggestion means. Does it mean have Windows Task Scheduler open Excel every 10 minutes? What I'd like is a macro that does the scheduling. Is that possible? And, how would I detect end of Friday? Thanks, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template downloads | New Users to Excel | |||
Macro to schedule downloads | Excel Programming | |||
Dynamic Dependant Downloads | Excel Discussion (Misc queries) | |||
File Downloads in VBA | Excel Discussion (Misc queries) |