Getting new assignment data

T

Timothy Tan

Hi, I'm in Project 2002, trying to intercept new
assignments before they are added into the project, to get
information about the resource out, but I can't seem to
find a good way to find out what resource is being added
to the task. Which vb event do I trap and use to get this
information?

Thanks.
 
R

Rod Gill

Events are all described in the Project VBA help. The trick is to fool Help
into searching the correct help file!@@##! I usually open the VBE, then
press Ctrl+GO to select the immediate window, type Project into it and then
press F1. This shows help on the Project object, but forces help to open the
Project VBA help file. Now I use the index to search further.

I would read data from your other app via automation and set a field (EG
Flag1) to Yes when the data is read. That way you are guaranteed to get all
information because you know when assignment data has been read (Flag1=Yes).

You could also run a macro in Project to export all assignments with
Flag1=No then set Flag1=Yes after a successful export.

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