J
josh.mallett
I have a lengthy process which takes upwards of an hour to complete.
For simplicity, simply assume it is a basic Do While loop which takes
approximately an hour to complete. I have added a progress bar to my
form to show the progress, but I was curious if there was any way to
list an estimated remaining time? I had tried to use something like
the code listed below but it doesn't give the expected results
(probably because it's overly simple). Any help would be greatly
appreciated!
dteTimeStart = Time
Do While CurrentCountInLoop <= MaxCountOfLoop
dteTimeElapsed = Time - dteTimeStart * 24 * 60 * 60
dteTimeRemaining = dteTimeElapsed * MaxCountOfLoop /
CurrentCountInLoop
Loop
Thanks,
Josh
For simplicity, simply assume it is a basic Do While loop which takes
approximately an hour to complete. I have added a progress bar to my
form to show the progress, but I was curious if there was any way to
list an estimated remaining time? I had tried to use something like
the code listed below but it doesn't give the expected results
(probably because it's overly simple). Any help would be greatly
appreciated!
dteTimeStart = Time
Do While CurrentCountInLoop <= MaxCountOfLoop
dteTimeElapsed = Time - dteTimeStart * 24 * 60 * 60
dteTimeRemaining = dteTimeElapsed * MaxCountOfLoop /
CurrentCountInLoop
Loop
Thanks,
Josh