Batch Create MS Project files from excel data

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

Blocked Profile
Jul 31, 2015 at 11:21 AM
Ok, so you wish to change a Row in Excel, into a task in Project?

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