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

Ezio Puiatti 1 Reputation point
2021-06-28T04:07:57.917+00:00

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

0 comments No comments
{count} votes