View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andyjim Andyjim is offline
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