Recrring timer for VBA code

[A1CLowe]

Hello again,

I have a VBA code I would like to have automatically ran every monday, now I'm sure it has something to to with an OnTimer event. However; I'm not sure how to set this up to run weekly, I know that there are 604800000 milliseconds in a week but I've tested with 6 milliseconds and this only runs the code once and not again. Any assistance would be great!

 

[pbaldy]

Personally I'd create a db that performed your process when it opened, then quits, and run that db from Windows Scheduled Tasks.

 

[A1CLowe]

Now, Noob question, can that other database read the information i need from my existing one?

 

[pbaldy]

Sure; you link to it using the external data function.