none
Copy Custom Task Text field to Assignment Text RRS feed

  • Question

  • Hi

    I have recently moved from MS Project 2003 to MS Project Standard 2010.

    One of the macros that I commonly used took the task field (Text8) and copied this to the Assignment Field(Text8).

    There have been some similair questions on the forum however I would appreciate some specific help with this.

    The previous macro I used is as follows, with a typical value for Task text 8 being "20007.25BB.010"

     

    -------------------------------------------------------------

     Incorrect macro removed

     

     


    • Edited by Davie_Quinn Wednesday, November 9, 2011 9:30 AM
    Thursday, November 3, 2011 10:43 AM

Answers

  • Davie,

    I don't see a specific question associated with your post. However, starting with Project 2007, Project introduced two separate sets of extra assignment fields. If you are experiencing a problem with your existing macro, go to the MVP website at, http://www.mvps.org/project/faqs.htm, and take a look at FAQ 37 - custom fields in views. Then if you still have a question, post back with specifics.

    Hope this helps.

    John

    • Marked as answer by Davie_Quinn Wednesday, November 9, 2011 9:29 AM
    Thursday, November 3, 2011 4:03 PM

All replies

  • Davie,

    I don't see a specific question associated with your post. However, starting with Project 2007, Project introduced two separate sets of extra assignment fields. If you are experiencing a problem with your existing macro, go to the MVP website at, http://www.mvps.org/project/faqs.htm, and take a look at FAQ 37 - custom fields in views. Then if you still have a question, post back with specifics.

    Hope this helps.

    John

    • Marked as answer by Davie_Quinn Wednesday, November 9, 2011 9:29 AM
    Thursday, November 3, 2011 4:03 PM
  • Shouldn't r be replaced by A in your code?

    Rod Gill

    The one and only Project VBA Book Rod Gill Project Management
    Saturday, November 5, 2011 6:54 AM
    Moderator
  • Aplogies Gents

     

    This was posted incorrectly. Since moving from 2003 to 2010 the following macro no longer works.

    I will have a look at FAQ 37 as I think this has the information I need

     

    Thanks

     

    Davie

     

    Sub CopyShortNameToAssignment()
    'This macro copies information in the task text8 field
    'into the assignment text8 field so that is can
    'be displayed in a usage view or in a report.
    'Modify the line noted below to fit your needs
    Dim t As Task
    Dim ts As Tasks
    Dim a As Assignment


    Set ts = ActiveProject.Tasks
    For Each t In ts
    If Not t Is Nothing Then
    For Each a In t.Assignments
    'change the following line to use
    'for a different custom field
    a.Text8 = t.Text8

     

    Next a
    End If
    Next t
    End Sub

    Wednesday, November 9, 2011 9:07 AM
  • Hi,

    The macro will work allright (at least if you have the right security settings) but maybe you think it doesn't work because you don't see the assignment's text8 in Resource Usage; you will see it in Task Usage allright, and why not in resource usage is explained in the FAQ.

    Greetings,

    Wednesday, November 9, 2011 1:25 PM
    Moderator
  • Thanks Jan
    Thursday, November 10, 2011 2:10 PM