MS Project macro question

Question

Hi,

I am trying to use a macro to create a custom status field, using the text2 field.  I tried using the record function which produced this code:

Sub Macro1()

' Macro Macro1

' 

    SelectTaskColumn Column:="Task Mode"

    TableEditEx Name:="&Entry", TaskTable:=False, NewName:="", NewFieldName:="Text2", Width:=9, ShowInMenu:=True, LockFirstColumn:=True, DateFormat:=255, RowHeight:=1, ColumnPosition:=1

    TableApply Name:="&Entry"

    TableEditEx Name:="&Entry", TaskTable:=False, NewName:="", FieldName:="Text2", NewFieldName:="Text2", Title:="", ColumnPosition:=1

    TableApply Name:="&Entry"

   SelectTaskField Row:=1, Column:="Text2"

End Sub

When I recorded the macro, the desired new field was produced.  However, when I try to run the code as a macro within a new project, it errors on

SelectTaskField Row:=1, Column:="Text2"

Run-time error '1101': The argument value is not valid

I have a second macro, which will be combined once I get over this error, that renames the field and assigns G-Y-R indicators.  

The reason I am using a macro is that multiple people will be using adding the status to their reports.

Any assistance is appreciated!

Answer 1

John,

Thanks for the reply and explanation. 

I am attempting to insert a column in the first position.  The column will be for a R-Y-G indicator for the task or phase.  I have the code in a macro for the indicator, I can not figure out how to insert a column via a macro.

Answer 2

RedMan_567,

Recorded macros operate on the active view (foreground processing). When you recorded the macro your view showed the Text2 field. When you opened a new project, the Text2 field was likely not displayed as a column, hence the run-time error.

For reference, macros written to operate directly on Project objects, (e.g. tasks, resources, assignments, etc.), the code is independent of the view and normally faster, particularly with larger files. If you can tell us more about what exactly you want to do with the Text2 field, we can help you write more efficient code.

Hope this helps.

John