customized column proprieties

[Hernandezz]

Hi,

Do you know how in VBA I define customized column proprieties? For
exemple I can obtain the customized colmun values,
activeproject.projectsummarytask.Number1

but I want for example
activeproject.projectsummarytask.Number1."title", it is possible??

thanks and good work

 

[Rod Gill]

Hi,

This group is closing soon, so please use the programming group in future.
To answer your question, try:

Sub test()
Dim TblFld As TableField
For Each TblFld In ActiveProject.TaskTables("Entry").TableFields
If TblFld.Title = "" Then
Debug.Print Application.FieldConstantToFieldName(TblFld.Field)
Else
Debug.Print TblFld.Title
End If
Next
End Sub

This will print all field names or titles (if a column has one) for the
Entry table.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Hernandezz]

Hi,

This group is closing soon, so please use the programming group in future..
To answer your question, try:

Sub test()
Dim TblFld As TableField
    For Each TblFld In ActiveProject.TaskTables("Entry").TableFields
        If TblFld.Title = "" Then
            Debug.Print Application.FieldConstantToFieldName(TblFld.Field)
        Else
            Debug.Print TblFld.Title
        End If
    Next
End Sub

This will print all field names or titles (if a column has one) for the
Entry table.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com









- Mostrar texto citado -

OK Rod, thanks for all.