Time comparison
Hi,
t1=Timer( )
....
t2=Timer( )
total = t2-t1
--
Regards,
Sébastien
"Gixxer_J_97" wrote:
Hi all
I am trying to figure out what section of my code is running the longest.
how do i compare two times (ie subtract the two so that i can get a total
time run)
sub MyCode()
dim t1, t2, total
t1=time
<my code
t2=time
total=<how do i work with the time here
msgbox total
end sub
is this the correct way to do this or is there a better way?
and secondly is there a way to write one sub and have it triggered any time
that code is run, without putting a call to it in each of my functions?
basically i want to see how long each section of my code takes to run, so i
can see where the slowdowns are and possibly re-write, etc
tia!
J
|