Run Every 15 mins

R

Richard

Hi

I have a workbook, in which I have a workbook_open macro. After the initial
run I would like the workbook to stay open and the macro to run every 15 mins
throughout the day and then close at a specific time, say 19:00.

What is the best way to do this. I had thought of a delay at the end of the
first run, with the next line being workbook_open.macroname, but I wasn't
sure if this was the best method.

Thanks for the advice
Richard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to close excel worksheet after 15 mins? once it opened 5
Run code every 15 minutes 5
Rounding Time down 4
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Application.OnTime 2
Data in Tables updates every 15 mins 1
Runtime error 1004: Select method of worksheet class failed 3

Top