
Data from hidden column or make column visible
Hi,
MsgBox "Contents of Text14 for the first task of the active project: " &
ActiveProject.Tasks(1).Text14
To see how to insert or delete a column, record a macro (Tools, Macro,
Record New Macro) of you inserting and deleting a column then stop recording
and look at the code in the VBE.
--
Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
add-ons
Rod Gill
Microsoft Project MVP
Visit www.projectlearning.com for customized Project and Office VBA macros
and Project companion software
Quote:
> G'day,
> I want to get data from a hidden column in Project98. The column is a text
> field (eg Text14).
> I don't want to have the column displayed, but could handle having it
there
> temporarily to copy the data and then hide again.
> I can work out how to hide a column in code, but I can't seem to make a
> column appear (ie make it visible).
> How can I either copy from a hidden column or make a column appear via VBA
> code???
> I would greatly appreciate any help.
> Thanks,
> David Stumbles