Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Run a macro on a fixed date cycle
Hi
Is there a way to run a macro - "Update_Me" - on a fixed date, say the first of every month? Thanks in advance Steve |
#2
|
|||
|
|||
Steve,
There's no way to do waht you want without opening the workbook on that day. If we assum you open the workbook everyday, the ideal way to achieve ehat you want is to create ans 'Auto_exec' macro that performs a check on the date, and then either exits doing nothing, or runs your update macro, depending on the result of the date check. Depending how volatile your source data is you may need to add some validation and safety checks to ensure the macro is run only once per month, but that should be fairly ewasy for anyone with some basic VBA knowledge. HTH Neil www.nwarwick.co.uk "Steve" wrote: Hi Is there a way to run a macro - "Update_Me" - on a fixed date, say the first of every month? Thanks in advance Steve |
#3
|
|||
|
|||
Maybe you could use a windows scheduler that starts your workbook on certain
dates. Then call your Update_me in the auto_open procedu sub auto_Open() call Update_Me thisworkbook.close savechanges:=true 'maybe??? end sub Steve wrote: Hi Is there a way to run a macro - "Update_Me" - on a fixed date, say the first of every month? Thanks in advance Steve -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert date in macro | New Users to Excel | |||
How do I insert the date using a macro | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
how to alter the date within a macro | Excel Discussion (Misc queries) | |||
Date and Time Macro | Excel Discussion (Misc queries) |