aplication.ontime

I'm trying to get a messagebox to open and display a message, I found this code below but it doesn't work I've tried putting the Private Sub in the workbook and the Sub Display Alarm() in a module but nothing happens. Private Sub Workbook_Open() Application.OnTime TimeValue("17:24:00")...

M not able to run this code in every 15 min ...someone pls help me ... the code start at 9;15 am and it's copy the value in every second from RTD data from Column 2 (in subsequent rows) but i want that the code copy data in every 15 min only. Suppose at 9:30 am the code starts and copy the value...

Sub SaveThis() Application.DisplayAlerts = False ThisWorkbook.Save Application.DisplayAlerts = True Application.OnTime Now + TimeValue("00:00:10"), "SaveThis" End Sub This is in WB1. If I have a second Workbook open, it will automatically open WB1 each time the Application.Ontime timer runs...

Dear, I would like to have a macro running automatically on a daily basis (if workbook is opened), on assigned schedule, and based on the environment user name. I have come up to the following code, but it does not work, and need your assistance to perfected: Sub RunSchedule() If...