LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Macro to schedule downloads

Hi,

I want to download market data into Excel every 10 minutes from 6PM Sun to
5PM Fri. I have a macro (GetQuotes) to do the actual download, which works
fine. But I have no clue how to VBA running that macro on a schedule,
stopping on weekends. The scheduling macro should launch when the file opens,
and of course it needs to know the date and time automatically. Further, I'd
like to be able to interupt and restart the scheduling macro without closing
the file.

Andy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Template downloads Bruce Burlingame New Users to Excel 1 November 5th 08 12:01 AM
Dynamic Dependant Downloads Philip J Smith Excel Discussion (Misc queries) 14 March 6th 07 02:31 PM
Comma delimiter for csv downloads? Les M Excel Discussion (Misc queries) 7 January 31st 06 01:03 AM
File Downloads in VBA Sysygy Excel Discussion (Misc queries) 1 April 8th 05 06:45 PM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"