Win 2k and xp
Excel 2k

Requirement: Want to track how much time I spend on each
workbook for edit time. Word has a builtin_document
parameter but excel does not.

Has anyone got some code/workbook that they are using.

If I have to build myself, a few questions.

per Chip's site

Window Activate/Deactivate does not trigger when switching
applications. To catch this I guess I would need to trap
the application activate/deactivate events.

So, if I'm working on book 1 and flip to Outlook, I need
to record on my sheet a "time stop" value, or if I flip to
another book within excel I also need to record time stop.

if I switch from outlook to excel book 2, will need to
record the time start for book2, and when going from book
2 to book 1 I need to record stop for book 2 and start for
book 1.


I'm struggling with the logic that I would use to record
to a tracking sheet. On book open I note time, on book
close, I record the close time---total edit time is the
difference less any time not within this book, or not
within excel app.

How should I set up monitoring of time not in this book or
not in the application.

If I were to set this up as a class event and wrote to
personal.xls each book and the time spent, is that the
best way to go about this.

TIA

Dave