Are you Genius - Please HELP

[uni]

hi,

Does anyone know how to access information stored within the controls of a ms office application. For example, if a user had an email open in outlook, or a project open in ms project, how would you go about extracting the information from the fields on the screen.

Also, is there anyway of being able to tell when a user has deleted or added a value to a field in either of these application - which activates a function in a vb app. Would a macro be the way to go?

Thanks heaps,
uni

[srinika]

Hi!
This is not a complete answer but a guidance
U can use Windows APIs to find the handle of the Window in which the application u need is open. Also using APIs u can find the handle of the control to which u r refering to.
Thus by using those features u can get the information u need. I'm not an API expert but I'm sure u can get something from this path
Good Luck
Srinika

[uni]

This is a good idea.
Can anyone explain this better (does anyone have some sample code)?

Thanks,

uni