OLE Automation

[sonal]

Hi All,

I want to run my timer application whenever any Microsoft Office Application starts.

e.g :->
Suppose a user starts Word , my timer application should start showing him the time for which he has been using word.

also it should work concurrently if i start Excel , Access etc.......


the punch is to show the user how much time he has been working on each application individually.

Can anyone suggest me how to start my application when any office application gets started ....

Thanks
SONAL

[NeedSomeAnswers]

I have never done this before, so i am taking a shot in the dark but:-

When ever Word or Excel open they start a new Process, couldn't you "listen" for the process to start.

Task manager knows when a new process has started so thier must be an API out thier somewhere that can help you !

Obviously you would need to know the process names for WORD, EXCEL and the like !

[RobDog888]

Easiest way: no programming required.

In MS Outlook, go to the Journal folder and you should get a
prompt if its not on.

[RobDog888]

Then select your Journal options you want to record time of.



Then click 'OK'.

[RobDog888]

Then you wil see a timeline. After you have done some activity in
a tracked Office application's file, the timeline will show the Office
apps file that you were working in.




VB/Outlook Guru!