auto lookup effect

[Mayu]

The effect I'd like to achieve is a sort of seamless linkage of programs. On
something like an Excel file, there will be some 'Task Names" listed. When a
user clicks on a task in the Exel file, I want it to automatically bring up
an MS Project (mpp) file associated with that Excel file and to
automatically go to the selected task in the mpp file.

Manually, at the moment, a user would have to open the mpp file and do a
'ctrl find', enter the 'Task Name" into the Find dialogue, and close the
dialogue, in order to find the same 'Task Name" in the mpp file.

If anyone could offer any advice as to how this could be achieved, it be
greatly appreciated,

thanks!


Mayu

B. Engineering, 4th yr

 

[Jan De Messemaeker]

Key is the GetObject method. Look up the help.
HTH