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
Peo Sjoblo #2 / 2
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??
Running a macro a specified Time of day