Re: app to monitor time editing office documents




<frannykilledzooey@xxxxxxxxx> wrote in message
news:1121980936.661911.204080@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Trying to write a time tracking app with the following behavior:
>
> 1. Lives in system tray (have seen all posts saying how to do this)
> 2. Monitors office apps (word, excel, visio, outlook, powerpoint)
> 3. Monitors document (or email) open and close events, timer times
> amount of time spent editing document, pops up form to assign a
> project, after assigning project, submit form and posts time entry with
> project id and timer amount of time.
> 4. Stores project id with document so pre-populates project id next
> time form comes up for this document.
> 5. Has start/stop buttons in system tray app to do a custom punch if
> you are doing work it can't monitor.
> 6. future monitors other programs like telnet, etc. too.
>
> Any ideas how to monitor the office apps, open/close document events,
> pop up a form based on these, and store project id with a document?
>

Got an idea: VBA the macro


.