Batch Create MS Project files from excel data

[Closed]
Report
Posts
3
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 31, 2015
-
Posts
3
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 31, 2015
-
Hey everyone!
I am hoping to be able edit a MS project template using a macro.
With each project we do I have the project start date, task names, and each tasks duration in excel. All of the tasks follow each other linearly so there is no tasks that have multiple prerequisites.
If anyone has any experience with problems like this please let me know! I will be monitoring and will do my best to clarify anything

Thank you very much!


1 reply


Ok, so you wish to change a Row in Excel, into a task in Project?

Start first by telling us what version of each.
Posts
3
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 31, 2015

Both are 2013.

Yes, essentially that would be the intent.

Other functionality that would be nice would be changing the metadata of the project file and saving it according to the project name (also included in the dataset)

I would be running this to make project files for 5-25 projects at a time