Timed Macro

Hi

Is it possible to have Excel open, with a Macro running that will every two hours inport some data from a source then open a new tab in a different work book and paste it into that tab then close the workbook.

I have the code for inporting the data to the first workbook done, its the timing and copying to a new tab in a different workbook im stuck with.

Once it has imported the data, copied it to a new tab in the other workbook, I would like it to wait two hours then do it again, and keep running.

Any ideas ??

Thanks
David

Hi

I have one workbook called "current" and one called "history"

What I would like to happen is,

1. Workbook "current" stays open all the time with 1 worksheet called "currentdata"
2. Every 2 hours I woul like the macro with in "current" to update the data in this worksheet with new data.
3. Next copy all the data from this worksheet, in to a new tab in the workbook "history" close this workbook.
4. then start the cycle again.

Hope that explains.

Thanks
David

Hi

Yes, that is spot on.

A spefic time would be best, so I can leave the "current" work book open and not worry about what the time is.

Im thinking 10:00am then every 2 hours until I break the code or close down "current"

Thanks
David

The "OnTime" command will allow you to run a macro at a specific time or loop every n minutes ..

Heres a link to a nice little tutorial on it ... CAUTION : be carefull in setting up as you will need to cancel the command on closing.
http://www.ozgrid.com/Excel/run-macro-on-time.htm