I have a macro that runs every 5 minutes. Once it runs I then save the new data as a html so it can be seen in multiple places.
The code is simple
dtime = Now + TimeValue("00:05:00")
Application.OnTime dtime, "'My_Macro"
I then use another program to FTP the new file to another server.
I need to synchronize the updating of the new file. So I was wondering if there is a way to see the time remaining or the next run time of my timer.
The code is simple
dtime = Now + TimeValue("00:05:00")
Application.OnTime dtime, "'My_Macro"
I then use another program to FTP the new file to another server.
I need to synchronize the updating of the new file. So I was wondering if there is a way to see the time remaining or the next run time of my timer.
