Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Timed on-line downloads (excel 2000)

    I have to download the 'same data "updated" three times' in an hour from the same scource. (Data is continually updated.)
    I use different worksheets to store this data. I then unscramble the data to suit my needs.
    At the moment I download each update manually, changing from one worksheet to the next, etc.
    Is there a way of getting each worksheet to download the data automatically once I have done the first one manually?
    ie: Sheet one. Manual start for downloading. Thereafter, auto switch to sheet two and download on 'set time' from start of first sheet download. Then auto switch to sheet three and download on 'set time' from either first or second sheet.
    Thanks in advance for any inputs.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Timed on-line downloads (excel 2000)

    I am not sure what you mean by "download" and how you are doing it.

    To have excel do something at a particular time or a time in the future, you can use Application.onTime

    From the HELP:
    <hr>This example runs my_Procedure 15 seconds from now.
    <pre>Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"</pre>


    This example runs my_Procedure at 5 P.M.
    <pre>Application.OnTime TimeValue("17:00:00"), "my_Procedure"</pre>


    This example cancels the OnTime setting from the previous example.
    <pre>Application.OnTime EarliestTime:=TimeValue("17:00:00"), _
    Procedure:="my_Procedure", Schedule:=False</pre>

    <hr>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •