Results 1 to 2 of 2
2004-09-09, 12:28 #1
- Join Date
- Jul 2004
- 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.
2004-09-09, 13:47 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- 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"), _