question

EzioPuiatti-8684 avatar image
0 Votes"
EzioPuiatti-8684 asked

I would need a VBA routine to to update fields in a MS Project file from info provided on an excel file/s

My issue is very similar to that already answered in the link below but simpler is so far as the fields to be updated in MS Project are all in one excel file - see attached pic.

my requirements:

I have the spreadsheet - screenshot below - (yellow fields updated by various engineers) which I would like to use to update the active MS Project.
- I would like the code to prompt the user to select the excel file to be used for such update
- The fields name in MS Project to be updated are user defined fields and have the same names as in the sheet below (columns highlighted in yellow) - I intend updating the actual schedule manually after importing such data.

109762-progress-update.jpgthe fields to be updated are:

Revised_% (% field)
Revised_Start (date field)
Revised_Finish (date field)
Revised_Predecessors (Text field)
Comments (Text field)

many thanks
Ezio



https://social.msdn.microsoft.com/Forums/en-US/7f4b50af-ef39-4927-9adc-565ef4861634/updating-start-finish-complete-from-excel-file-to-ms-project?forum=project2010custprog


office-vba-dev
progress-update.jpg (130.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers