Setting column widths in Resource Usage View via VBA

[Peter Rooney]

Can anyone tell me how to do this?

My code produces resource views for a number of different teams, but if I
use "ColumnBestFit", the width of the column changes from team to team,
meaning that my prints don't contain the same number of weeks' worth of
information (one or two days get added to or dropped off from the end of the
print, depending on what width "ColumnBestFit" sets the ResourceName task to)

When i record myself altering the width of the column, I don't get anything
recorded.

Thanks in advance

Pete

 

[Jan De Messemaeker]

Hi,

Look up the help for the TableEdit method.
HTH

 

[Peter Rooney]

Jan,

I'll take a look on Monday, but in the meantime, thanks and have a nice
weekend!

Regards

Pete