Queris/Macro automatically running in a hourly basis

O

Omar

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.

[email protected]

Thanks!
 
J

John W. Vinson

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.

[email protected]

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]
 
Top