Ontime Event Going haywire at midnight

[Drumin_Phreak]

Hello! I have a excel project that starts an ontime event on workbook open. This thing works fantastic! However, when midnight rolls around it crashes. After doing some research I have surmised that the problem is when the date changes, the time is now After the initial time set. I tried to include the now function (dTime2= Now + TimeValue ("00:05:00") and this does nothing. The one that currently works is:

dTime2 = Time + TimeValue("00:05:00")
  Application.OnTime dTime2, "AutoSaves"

I have been struggling with this for quite sometime. If I could get any help it would greatly be appreciated.

 

[RoryA]

Can you post a workbook somewhere (e.g. OneDrive or Dropbox) that shows the problem you are having?