old projectified

where brian kennemer used to endlessly obsess about project server, so that you did not have to

Browse by Tags

Related Posts
  • Blog Post: Moving Tasks With VBA

    So the problem was that a customer wanted to be able to move a task that was at ID 7 and move it so that it was at ID 2. Sadly, VBA for Project does not contain a Task.Move method. But with a little bit of code around them you can use a Cut and Paste methods for Rows. The example below assumes that you...
  • Blog Post: Three Point Estimation (PERT) in Project 2010: Take 1

    As some of you may already know the PERT Addin that was in Project for several versions was NOT included in Project 2010. The good news is that below we have the first version of some sample code you can use to add the feature back into the product! This first version does not use a form like the old...
  • Blog Post: No Thanks, I’ll Be Having the Crow

    File this under reason 467 why I don’t make my living as a full time developer. Yesterday I posted some code for parsing out a comma delimited text field, such as a multi-value enterprise field in Project Server 2007. Today a real developer pointed out that there is a function that does the same thing...
  • Blog Post: Code to Show Which Tasks have Which Baselines Saved

    Here is a sample of some VBA code that will populate the Task Text30 field with the numbers of the baselines for which each task has values saved. This is useful if you are using lots of the baselines but not all your tasks have had all the baselines saved. For example: “Task” has values in Baseline...
  • Blog Post: VBA Code For Parsing a MultiValue Text Field

    If you are in Project Server 2007 you can have an Enterprise Text using a lookup table that can contain more than one value. If you then need to work with that field data in code (VBA or VSTO) you can use the GetField function to get the value of that field. The catch is that it is returned as a comma...