Two Quick Questions

[egun]

1. Knowing a UniqueID, how can I reference the task in VB? Tasks are
reference by, e.g., ActiveProject.Tasks(ID). Is there a UniqueID to ID
conversion method? I'm trying to re-import data that was exported to Excel
using the task UniqueID, since the ID (row number) may have changed.

2. Is there an easy way to enumerate all of the task field names in a
Project (e.g. "Name", "Start", "Text4", etc)? I want to spit them out to
Excel (for a good reason!), but I can't find a collection of any kind for the
field names.

Thanks,

Eric

 

[Rod Gill]

Hi,

1) try Activeproject.tasks.uniqueid(1)

2) Not for all fields, but try the tablefields property of a table to
iterate through all fields in a table.
Alternatively if you use Project 2000+ you can use oledb from Excel to read
Project data directly from .mpp files which is very quick. However, it's
read only and P2000 doesn't support timephased data and P2002 calculates
daily work for timephased wrongly but weeks etc correctly.
Read prjoledb.htm in one of Project's program folders.

 

[egun]

Thanks for the reply. Both suggestions will work well for me.