Alovorn said:
Is there a way to export the entire list of pred/succ from a Project file to
Excel without truncating the data? I am trying to view all pred/succ in
Excel, but it is exporting some of the long lists with "..."
Alovorn,
When using an export map or a simple copy/paste, text based fields
(including Pred/Succ) are limited to 256 characters or the first line
feed. However there are several ways to work around this. First, review
the Predecessors and see if it really makes sense to have them all.
Eliminate unnecessary or redundant links. Note that if some of the
Predecessors are external, the full path name chews up a lot of
characters toward the character limit when exporting. Second, if you
have experience working directly with Project's database, the full
Predecessor text string can be queried via SQL (although I've never done
it). Third, VBA can be used to export the full text string. I have used
that method many times and have a couple of macros for it. If you want
more information, write me direct.
Hope this helps.
John
Project MVP
