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



--------------------------------------------------
http://szh.20m.com
http://gomusharrafgo.20m.com