Column Width & Row Height in a macro

[Sameer]

Hello,

Does anyone know of a way to adjust the column width and
row heights of a view in a macro. I know there is the
ColumnBestFit method which opens the column so all data in
the column is shown. However, i have data (such as a date)
that is not that large, but column headings that are long
(such as Finish Date Pre-Leveling). That is why I have to
adjust the column widths so everything fits nicely in a
legal sheet of paper. For this view, all the column widths
are going to be constant in each project this macro is run
on. Is there a way in the macro to set the column width in
MS Project? Any work around solution would be much
appreciated.

thanks

 

[Jan De Messemaeker]

Hi,

Look up the help for the TableEdit method. It's a bit lengthy to code, but
it's all in there.
A simpler way is probably to store a table in the Global, the use
OrganizerMoveItem method followed by TableApply.

HTH