Run macro only on Monday.

[Anonymous]

I have an application that updates every day.
I need to run a macro after this update only on Monday.

Does anyone have an idea how to do this?

[CELAMBARASAN]

Hi,

     You can restrict it inside the macro itself

if(DatePart("w",Date(),1) <> 2) then

          exit sub

end if

Which should be at the start of the sub routine

Celambarasan