Running a macro a specified Time of day 
Author Message
 Running a macro a specified Time of day

I wish to run a macro twice a day, specifically 9.00am and 2pm each day.
What code do I use? I've seen occurances of the OnTime event but I'm not
sure how this can be applied.
Any help greatly appreciated!!

Also, the file is being used by numerous people with "Read Only" access,
which I want to keep, but would like the results of the macro to be saved
under the original file name if possible. Any suggestions, is it possible??

TIA

Steve



Thu, 08 Jul 2004 04:57:20 GMT  
 Running a macro a specified Time of day
http://www.cpearson.com/excel/ontime.htm

--
Regards,

Peo Sjoblom

Quote:

> I wish to run a macro twice a day, specifically 9.00am and 2pm each day.
> What code do I use? I've seen occurances of the OnTime event but I'm not
> sure how this can be applied.
> Any help greatly appreciated!!

> Also, the file is being used by numerous people with "Read Only" access,
> which I want to keep, but would like the results of the macro to be saved
> under the original file name if possible. Any suggestions, is it possible??

> TIA

> Steve



Thu, 08 Jul 2004 05:09:56 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Run a macro at either a certain time or at a specified time interval

2. run macro at a specified time

3. How to make macro run at specified time

4. Automating an e-mail macro to run a specific time every day without user intervention

5. Error Run time 2105 You cant go the the specified record

6. Running a query at a specified time

7. Running Access Run-Time from another Access Run-Time

8. Run-time Error 7 when running macro

9. Inserting last saved date/time into Excel/Inserting last run date/time of macro into Excel

10. Inserting last saved date/time into Excel/Inserting last run date/time of macro into Excel


 
Powered by phpBB® Forum Software © phpBB Group