로그인
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Free Format Duration VBA Macro for Project 2010

Discussion Free Format Duration VBA Macro for Project 2010

  • 2012년 4월 26일 목요일 오전 3:04
    중재자
     
     
    로그인하여 투표
    2

    Hi all,

    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.

    Enjoy!

    Rod Gill

    The one and only Project VBA Book Rod Gill Project Management

     

모든 응답

  • 2012년 4월 26일 목요일 오전 3:18
    중재자
     
     
    로그인하여 투표
    0
    Very cool. I wrote something a bit similar a bit ago for a toolkit addin Im working on. Hard to believe they took this out. :-)

    Brian Kennemer - Project MVP
    DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn

     
  • 2012년 4월 26일 목요일 오전 11:35
    중재자
     
     
    로그인하여 투표
    0
    My client was just asking for this in fact.
     
     
    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
     
  • 2012년 4월 26일 목요일 오후 9:02
    중재자
     
     
    로그인하여 투표
    0
    Well there you have it: synchronicity in action! Let me know how it goes.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

     
  • 2013년 3월 1일 금요일 오후 4:43
     
     
    로그인하여 투표
    0

    Rod,

    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.

    Garrett Rowley

     
  • 2013년 3월 1일 금요일 오후 6:19
    중재자
     
     
    로그인하여 투표
    0

    Hi,

    Pardon me jumping in hee. The answer is yes to all.

    Greetings,

     
  • 2013년 3월 2일 토요일 오전 11:53
     
     
    로그인하여 투표
    0

    Jan,

    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?

    Thanks, Garrett

     
  • 2013년 3월 3일 일요일 오후 2:05
    중재자
     
     
    로그인하여 투표
    0

    Hi,

    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 :-)

    Greetings,

     
  • 2013년 3월 4일 월요일 오후 1:53
     
     
    로그인하여 투표
    0

    Jan,

    I am actually looking to extract these data items from Project Server 2010.

    Thanks, Garrett

     
  • 2013년 3월 5일 화요일 오후 5:35
    중재자
     
     
    로그인하여 투표
    0

    Hi arrett,

    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.

    Greetings,