Previous Topic Next Topic

Batch Create MS Project files from excel data

Closed
avw Posts 2 Registration date Thursday 30 July 2015 Status Member Last seen 31 July 2015 - 31 Jul 2015 à 09:39
avw Posts 2 Registration date Thursday 30 July 2015 Status Member Last seen 31 July 2015 - 31 Jul 2015 à 11:26
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!


Related:

1 response

Réponse 1 / 1
Blocked Profile
31 Jul 2015 à 11:21
Ok, so you wish to change a Row in Excel, into a task in Project?

Start first by telling us what version of each.
avw Posts 2 Registration date Thursday 30 July 2015 Status Member Last seen 31 July 2015
31 Jul 2015 à 11:26
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