I have a
VB script in an Excel spreadsheet that imports data from a MS
Project file. Right now I have the Project fields that are being
imported hardcoded in the script, e.g. Name, Text1.
For Each task In MSProj.ActiveProject.Tasks
Cells(i,1) = task.Name
Cells(i,2) = task.Text1
i= i+ 1
Next t
I would like to be able to change which fields are being imported by
setting a value on a worksheet rather than having to change the code
each time. So if I wanted the Start and Finish fields for each task
rather than the Name and Text1 fields, I could change some cells from
"Name" and "Text1" to "Start" and "Finish". However, I'm not sure how
to change these strings into something that can reference the proper
field in the task object. Any suggestions.
Thanks.