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

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,502 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.