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:
I have been struggling with this for quite sometime. If I could get any help it would greatly be appreciated.
dTime2 = Time + TimeValue("00:05:00") Application.OnTime dTime2, "AutoSaves"