Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi all,

    i work all day with projet sructure plans (PSP-plans). I found a solution to solve the problem, getting psp-numbers, but the macro
    hangs up my system every time i want to get some structure codes out from indented text).

    does anyone know, what is wrong???


    Stef

    ps: Hans got me a solution in February/March to Sum a PSP/WBS -structure... the task now seems much more complicated.

    pps: i meant work breakdown structure... ;-(
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The code does not match the data in the worksheet - it loops through the cells in column B until it encounters "END OF PROJECT", but column B is blank so the code will get into an endless loop. Please post a correct workbook.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ahhh, i am that blind...

    ok, i copied, the text into column b and started the macro, but i worked only when i hit the ESC-button..

    maybe there could be another exit for it.
    stef
    Attached Files Attached Files

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    You forgot to complete the project with "END OF PROJECT" in Column B
    Regards
    Don

  5. #5
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ok, thats all to get a wbs structure out of indentet text.
    Thanks a lot to You,
    stefan


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •