Running macros at a specific time

[macsloth]

Hi there,

I was wondering if there is a way I can get a macro to run at a specific time every day?

Would really appreciate any suggestions! Thanks!

Cheers,

Julian Wee

 

[macsloth]

hi paul,

that's a good point. although i don't think there will be a sequencing problem as the macros are independent of each other, but all the same, i think i'll stagger them.

thanks so much for the help!!

 

[Krishna1]

Thank you Paul & Mac, This thread helped me.

 

[paildukkha]

All,

InThisWorkbook I have the below code

Private Sub Workbook_Open()
Application.OnTime TimeValue("08:50:00"), "workaround"
Application.OnTime TimeValue("19:40:00"), "Table_email"
End Sub

In the module, I have these macros


This file is always kept open, but for some reason, these 2 codes are not triggered.
Why?

 

[amalanta]

Hi Paul,

it works! thanks so much! just one more question, if i want to set it to run a few macros at that fixed time, i just put in 'Thisworkbook'

Private Sub Workbook_Open()
'Run PHPNDF at 4.30pm
Application.OnTime TimeValue("16:30:00"), "PHPNDF"
'Run TWDNDF at 4.30pm
Application.OnTime TimeValue("16:30:00"), "TWDNDF"
End Sub

with PHPNDF and TWDNDF being the 2 macros i need to run. Is that right?

julian

For all who are curious about this question

Hi Julian,

You cannot run both the macro at exact same time, as the process time may differ,
instead just use this,

Private Sub Workbook_Open()
'Run PHPNDF at 4.30pm
Application.OnTime TimeValue("16:30:00"), "PHPNDF"
'Run TWDNDF once PHPNDF is completed
Call TWDNDF
End Sub

Bcoz, the TWDNDF process will start only once the PHPNDF is done, and you can expect the system time to be "16:30:00"