Run a macro on a fixed date cycle

[Steve]

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

 

[Guest]

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

 

[Dave Peterson]

Maybe you could use a windows scheduler that starts your workbook on certain
dates.

Then call your Update_me in the auto_open procedure:

sub auto_Open()
call Update_Me
thisworkbook.close savechanges:=true 'maybe???
end sub