Using IeTimer in Excel Programming

[Tom Ogilvy]

Speaking of time, you need to fix your clock.

Use the either the built in Timer command or just use Time.

 

[Rob van Gelder]

If I recall, IETimer is no longer included in standard distribution. There's
another way which is recommended.

 

[Syed Zeeshan Haider]

Hello Experts,
I have Excel 97 Pro on Win98SE.

I have downloaded ietimer.cab and somehow installed it. I have tested it by
some simple means and the test was successful.
Then I tried to use it in a code which had many long and complex procedures.
Actually, I wanted to calculate time in which a certain result was acquired.

That's how I have done:
IeTimer is enabled before running the core procedures. The interval is
already set. In IeTimer's Timer event, a certain global variable is
increased by one after every second.
After the core procedures complete their task, ietimer is disabled and the
value of the variable containing time is displayed through a MsgBox.
As the core procedures are quite complex and contain many loops, therefore,
they take 5 to 900 seconds to accomplish a certain task depending on
processor speed.

Theoretically the right time taken should be displayed but practically the
time displayed is always zero. I don't understand why is it so.
Does Timer event of IeTimer never fire during the running of core
procedures?
If it is so how do I calculate time of accomplishing a certain task?

Thank you,

 

[Syed Zeeshan Haider]

Thanks Tom!
I couldn't understand your first line but you have given me a very good idea
which is very successful so far.
Now I am using system clock instead of any other time. What do you think
about it?

Thanks again!