TableEdit behavior

[Paul]

I need to add a column to project worksheet and I've
managed to achieve some success using the TableEdit method
in the following manor.

o_App.TableEdit Name:="&Entry", TaskTable:=True,
NewFieldName:="Text30", Title:="Job Status", Width:=10,
Align:=2, ColumnPosition:=2, AlignTitle:=1

o_App.TableApply Name:="&Entry"

It creates the column, unfortunately it changes the
worksheet in other areas. It un-hides, previously hidden
rows (width 0, becomes width 16). The column headers lose
their titles. The titles of the original worksheet are in
Portuguese complete with accents. After you perform the
TableEdit command, the headers change to the field name.

How do I insert a column without affecting the rest of the
worksheet.

Is there any printed documentation available for MS
Project VBA?

Thanks in Advance.
Paul

 

[Rod Gill]

Hi,

Try recording a macro to do what you want and look at the recorded code.

Please note that this group is closing down soon. Please use
public.developer from now on.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/