Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Have 2 create 2 new date fields after export from MS project 4 piv | Excel Discussion (Misc queries) | |||
Linking MS Project fields in Excel | Excel Discussion (Misc queries) | |||
Referencing .Net Remoting Services project in MS Excel Macro | Excel Discussion (Misc queries) | |||
Referencing Call to Another Project | Excel Programming | |||
Referencing Code from another project | Excel Programming |