Application.OnTime not working after converting from Excel 2010 to Excel 2016

[Dojorgen]

My simple run requests were working just fine until the 2016 excel upgrade. I tried to enable and disable options but nothing seems to be working.

Workbook:
Private Sub Workbook_Open()
Application.OnTime TimeValue(13:30:00), "Refresh"
Application.OnTime TimeValue(13:31:00), "Shutdown"
End Sub

Module:
Sub Refresh()
ActiveWorkbook.RefreshAll
End Sub

Sub Shutdown()
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

 

[shg]

That syntax is not valid.

Application.OnTime TimeValue([COLOR="#FF0000"][SIZE=4]"[/SIZE][/COLOR]13:30:00[COLOR="#FF0000"][SIZE=4]"[/SIZE][/COLOR]), "Refresh"

Also, the code will close whatever workbook is active, maybe not the one you want.

 

[Dojorgen]

oh right forgot to put that in i.e.:

Application.OnTime TimeVlaue("13:30:00"), "Refresh"

Is not working for me but it did in the past

 

[shg]

The code looks fine to me, and I don't have Excel 2016 to test. You might try ...

Application.OnTime Date + TimeValue("13:30:00"), "Refresh"

... but that would be unnecessary in Excel 2010.