Vba code to run subroutine in a specific time

[ExcelNewbie2020]

Sir,

Would like to ask for vba code that will auto run my subroutine in a specific time, let say at 5PM.

my subroutine "sendemail" works properly when i hit button (auto send email thru msoutlook) now, instead of a button, i would like to auto run the subroutine everyday at 5PM.

tried to add this line "Application.OnTime TimeValue("17:00:00"), "SendEmail" but did not work...

Note: my excel workbook and msoutlook is running though my pc is locked..

 

[MARK858]

Have you put the code line in a workbook open event in the ThisWorkbook module?

 

[ExcelNewbie2020]

the code is placed in a seperate module not in thisworkbook module. do you mean, i should transfer the code to thisworkbook module?

 

[MARK858]

The code needs to be in an event procedure so that the macro is triggered to run, most commonly in a Workbook_Open procedure in the ThisWorkbook module

 

[ExcelNewbie2020]

The code needs to be in an event procedure so that the macro is triggered to run, most commonly in a Workbook_Open procedure in the ThisWorkbook module

i think i am missing something.. so what i did now is i add a line in thisworkbook module
Private Sub Workbook_Open()

Application.OnTime TimeValue("10:00:00"), "SendEmail"
End Sub

hoping that at 10AM, this will run "sendemail" subroutine.. I adjust the time to test if it will run on the nearest time.. but it didn't..

 

[MARK858]

Did you close and open the workbook after putting the code in the workbook?

 

[ExcelNewbie2020]

Did you close and open the workbook after putting the code in the workbook?

you are absolutely right.. thanks mate.. really appreciated