Hi Kiza,
A really simple way to do this is create a new workbook with an autorun()
macro that opens your workbook and runs the macro.
Then create a task with windows schedule task feature to run the new
workbook.
--
John
johnf 202 at hotmail dot com
"kiza " wrote in message
...
| Hi,
|
| I have the following
VB Coding which activates macros on a regular
| basis automatically, if Excel is left open.
|
| Sub RunOnTime()
| Application.OnTime Date + TimeSerial(15,0,0), "Refresh"
| End Sub
|
| Refresh is the macro which is being run.
|
| The RunOnTime macro, activates the Refresh macro at 3pm every day.
| Is there a way, or does anyone know, how I can get a macro similar to
| this to run on a weekly basis rather than a daily basis as this one
| currently does?
|
| Thanks In Advance
| Kiza
|
|
| ---
| Message posted from
http://www.ExcelForum.com/
|