Setting timescale view

[DavidC]

I have set up an automated process to create an excel spreadsheet of tasks
requiring progress updates from the contractor. Everything works fine, but
for one small thing. The timescale window fills the majority of the window
and the details are almost completely hidden. It is a feature I have noticed
that happens when fields are hidden that the timescale window expands out
across the screen. As I hide some coulmns for the purpose of copying the
relevant data to the spreadsheet this phenomena occurs and needs manual
resetting to show the detail columns again. I am looking for a VB command
simillar to the field width command so that after resetting the fields I can
then set the timescale window width correctly.

Any thoughts will be appreciated.

Regards

DavidC

 

[Jan De Messemaeker]

Hi David,

I have problems imagining exactly what you see happening and exactly what
you want to see.
The timescale part (the right part of a Gantt Chart view always and
inevitably "expands" from 1984 till 2049.

But let me first help you with the leftmost half.
You could put up two or more tables with the desired columns shown/Hidden
and in VBA use
TableApply

Then about the bar inbetween left and right
Have you experimented with the
SetSplitBar
method?

Then you can format the timescale with the TimescaleEdit method.
HTH

 

[DavidC]

You pretty much got it right. It is that feature of the timescale part of
the Gantt chart where the 'problem' occurs.

I normally edit the project with that part of the chart near to closed so
that I can view the maximum number of fields in the detail part of the chart.


When a column is hidden the portion of the Gantt chart I will call the
timescale view expands to cover some of the remaining columns. This is easy
to rectify by simply 'pulling' the split bar to the right, but after
exporting the fields to Excel that I need, and restoring the fileds to their
original position, the timescale has expanded virtually the full width of the
screen to the left. What I am looking for is a VB code to set the timescale
split back to the far right of the screen.

Hope this helps explain the 'problem', and thanks for all your help for this
and my other question.

Regards

David C

 

[Jan De Messemaeker]

Hi,

You should have tried my advice...
What you look for is called SetSplitBar
HTH