Using IeTimer in Excel Programming
 

Speaking of time, you need to fix your clock.

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

--
Regards,
Tom Ogilvy

"Syed Zeeshan Haider" wrote in message
...
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

Using IeTimer in Excel Programming
 

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Syed Zeeshan Haider" wrote in message
...
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

Using IeTimer in Excel Programming
 

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

Using IeTimer in Excel Programming
 

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!
--
Syed Zeeshan Haider



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

"Tom Ogilvy" wrote in message
...
Speaking of time, you need to fix your clock.

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

--
Regards,
Tom Ogilvy

"Syed Zeeshan Haider" wrote in message
...
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