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
|