26. dubna 2012 3:04Moderátor
Project 2010 no longer has Microsoft's VBA macro to format durations. There have been a number of requests for the same functionality in Project 2010 here in this forum and elsewhere, so I've written a replacement macro. In fact I couldn't resist improving it so this macro formats either all tasks in the active project or all selected tasks in the active project.
To download a copy, visit http://www.projectvbabook.com and click the Sample VBA Code button.
This is a freebie, so all care but no responsibility.
Rod GillThe one and only Project VBA Book Rod Gill Project Management
26. dubna 2012 3:18Moderátor
26. dubna 2012 11:35Moderátor
26. dubna 2012 21:02ModerátorWell there you have it: synchronicity in action! Let me know how it goes.
Rod Gill Project Management
1. března 2013 16:43
I am looking for a way to get at the following Project Server 2010 fields: Constraint Type, Unique ID Predecessors, Unique ID Successors. I can download most everything from the Reporting database but those three fields in particular do not exist in the database schema. Ergo, I cannot extract them. Are they somehow generated by Project Professional once the schedule is opened?
Any help would be appreciated.
1. března 2013 18:19Moderátor
Pardon me jumping in hee. The answer is yes to all.
2. března 2013 11:53
Based on your reply, I can only conclude that what I want to do is not possible. Is there a way for me to calculate that data using the same algorithm that Microsoft uses?
3. března 2013 14:05Moderátor
Isn't it much smpler to open the file and read them in VBA from Project Professional? Your allergy to Professional must be quiet strong if you prefer to recode part of its scheduling engine :-)
4. března 2013 13:53
I am actually looking to extract these data items from Project Server 2010.
5. března 2013 17:35Moderátor
You replied yourself, I quote:
those three fields in particular do not exist in the database schema. Ergo, I cannot extract them. Are they somehow generated by Project Professional once the schedule is opened?
And my reply to that is yes. No need to calculate them, they are there in Professional but not in Server.