Queris/Macro automatically running in a hourly basis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I run queries automatically at different hours/minutes per day?. The
queries are set in the same spreadsheet.

I want to record stock quotes prices every 5 or 10 minutes, and had
programmed web queries, then I need excel to run this queries for every each
of these periods of time, so that I get historical data in a hourly basis for
one given day.
Currently, the spreadsheet is open at the beginning of the day by using
windows tasks, and saved and closed one hour after the bell.

(e-mail address removed)

Thanks!
 
How can I run queries automatically at different hours/minutes per day?. The
queries are set in the same spreadsheet.

I want to record stock quotes prices every 5 or 10 minutes, and had
programmed web queries, then I need excel to run this queries for every each
of these periods of time, so that I get historical data in a hourly basis for
one given day.
Currently, the spreadsheet is open at the beginning of the day by using
windows tasks, and saved and closed one hour after the bell.

(e-mail address removed)

Thanks!
Click to expand...

If you're doing this in Excel, please repost your question in an Excel
newsgroup. This newsgroup is for a different program, Microsoft Access.

John W. Vinson [MVP]
 
Back
Top