TaskColumns

[MWE]

I am running Project2000 under WinXP.
I am trying to write VBA code to sequence through all
visible TaskColumns, capture their "names" and then hide
them. I am pretty experienced writing VBA code for other
MS appls.
The action to hide/delete a col easily found by recording
a macro; but I can not find a way to know how many cols
are visible, sequence through the visible cols and capture
their names.

Any help would be appreciated.

Thanks

 

[Rod Gill]

Hi,

Why hide columns? Why not create a new table (View, Table, More tables...)
and apply that? Restoring original columns is then only a matter of applying
the original table.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

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

 

[MWE]

For the particular case, your method may be better. But I
am also trying to learn how to do general things and want
to know how to:
1 identify the number of taskcolumns
2 identify individual taskcolumns and their properties
3 operate on individual taskcolumns

So, how do I do what I originally asked about?

Thanks

 

[Rod Gill]

In 2002+ you can read column data (search for filed and table in the object
browser). However, tables are the recommended solution for all column
manipulation. Tableedit lets you change columns.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

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

 

[MWE]

Rod: I have taken your advice and simply manipulate two
tables via VBA to accomplish most of what I want. This is
not quite as generic a solution as I want, but it will do
for now; and I suspect that I can make it generic as I
learn more about table manipulation.

I am still having trouble with one aspect of the total
solution: I want to move (via VBA control) the vertical
bar that splits the two halves of the Gantt view. Further,
I want to move it to a "location" between two specific
taskcolumns.

Thanks for your help

 

[Rod Gill]

Hi,

Not sure this can be done. Record a macro of you doing it manually. Nothing
will be recorded if it can't be done for your version of Proejct..

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

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

 

[Jan De Messemaeker]

Hi,

Setsplitbar(numberofvisiblecolumns)
HTH

 

[Guest]

Jan: thanks; very helpful. What if I want to move the
splitbar to the far right side of the window (essentially
hiding the Gantt chart details)?

Thanks