activating cell

[Mayu]

How would I go about activating a cell (task) in a mpp (MS Project) file,
programmatically?

is it something with ActiveCell property?

thnks,

 

[Rod Gill]

Hi,

Start by recording a vba macro. That will show you much of what you need.
However, code that selects different cells to work will run very slowly and
will be unlikely to work in the future when the schedule changes.

Much better to use the underlying object structure and avoid selecting cells
at all. Code will be more reliable and faster.

Post back details of the solution you are trying to develop and we can give
some architectural advise on how to develop your solution.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Mayu]

Thanks Rod,
I see that by recording macros, I can see what codes to use.
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.


Mayu