Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Schedule downloads

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andyjim - 23 Jan 2008 00:19 GMT
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
ryguy7272 - 23 Jan 2008 20:24 GMT
As stated in your other post..................
This will get you most of the way there:
http://www.cpearson.com/excel/OnTime.aspx

Insert your code in the appropriate place and you should be in business.

Regards,
Ryan--

Signature

RyGuy

> 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
[quoted text clipped - 12 lines]
> Thanks,
> Andy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.