WBS numbering

[DavidC]

Hi,

I feel I know the answer but would like confirmation or hopefully a work
around.

I have been asked to set up the WBS to mirror the WBS used in the financial
system (SAP). I can understand the reason, it would help in forecasting cash
flow on the project. The problem is that the structure used is:

Level 1 D##.####
Level 2 .##X
Level 3 .##X
Level 4 .##X

and example WBS is

D07.2000.01C.02C.04C

I suspect that I cannot define the code to macth this requirement using the
WBS setup under 'Project', and have to manually enter every code.

Any comments would be helpful.

Regards

DavidC

 

[Rod Gill]

You can create a predecessor string for outline codes, but not successor. I
suspect you may well need a VBA solution to do this. The code would prompt
for the strings you need (defaulting to what has previously been entered for
the active project) then loop thru each tasks creating the WBS in a custom
Text Field such as Text1

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[DavidC]

Thanks Rod, thought that might be the case.

You can create a predecessor string for outline codes, but not successor. I
suspect you may well need a VBA solution to do this. The code would prompt
for the strings you need (defaulting to what has previously been entered for
the active project) then loop thru each tasks creating the WBS in a custom
Text Field such as Text1

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx