Skip to content

P3.1

Santhosh kumarMember for 18 years
Created
18
1
0
Is it possible to export WBS description and activity code description to Excel and then import that to P3.1?

18 replies

Oldest first
  1. 0
    Shah. HB ·
    Hi

    You could do it that option is available in export
  2. 0
    Santhosh kumar ·
    Hi Shahul,

    You can export Activty codes and WBS ,but iam talking about activity code description and WBS description.
  3. 0
    Shah. HB ·
    you r right , description have to be done manually as of i knew
  4. 0
    Anbin Ponnith ·
    Dear Santhosh,

    We can get WBS description and Activity code description using RA applications. (Project .xls)


    With Thanks & Regards,

    Anbin Ponnith
  5. 0
    Santhosh kumar ·
    Dear Anbin,

    Could you please elaborate upon that?
    Is that a batch file?


    Best Regards,
    Santhosh
  6. 0
    Anbin Ponnith ·
    Dear Santhosh,

    It comes along with P3 CD.Its in the folder RA Application.

    Its a excel file developed with macros.

    regards,

    Anbin Ponnith
  7. 0
    Santhosh kumar ·
    Dear Anbin,

    Thanx for the reply.
    But could you please tell me ,how i can export the WBS description & activity code description from P3.1 to excel and then import the same to another P3.1 project.


    Best Regards,

    Santhosh
  8. 0
    Anbin Ponnith ·
    Dear Santhosh,

    After opening the Project.xls. It will show a security warning.Just enable it.

    Then enter your P3 user name& password.

    Then there is a box Get WBS Dictionary.Just click it.It asks the project to be opened.Just give your project location.You will get the details.

    After you change any details click the box.Set WBS Dictionary.
    once again it asks the project to bet set.Give the location.It will automatically get updated in the project.

    Regards,

    Anbin Ponnith
  9. 0
    Santhosh kumar ·
    Dear Anbin,

    Thanx a lot.I got it.


    Best Regards,

    Santhosh

  10. 0
    Atif Ali ·
    Dear Anbin
    i tried this new Option on ma system & it getting an error Message " Could not load an object becauz its not available on this machine"
    I have P3.1 already installed on ma machine so kindly give me some solution.

    Regards,

    ATIF
  11. 0
    Anbin Ponnith ·
    Dear Atif,

    Could you please show which error message are you getting.So that I can sort it out.


    With Thanks & Regards,

    Anbin Ponnith
  12. 0
    Atif Ali ·
    Dear Anbin,

    its

    "Could not load an object becauz its not available on this machine"
  13. 0
    Anbin Ponnith ·
    Dear Atif,

    Do you have RA application in your P3 CD that you have installed?

    If not give me your mail id I will sent you.



    With Thanks & Regards,

    Anbin Ponnith
  14. 0
    Anbin Ponnith ·
    Dear Atif,

    The RA application excel sheet runs with Active X controller.Please enable it or prompt it.Also make the macro security level low in our excel function.



    With Thanks & Regards,

    Anbin Ponnith
  15. 0
    Anbin Ponnith ·
    Hai Atif
    Sorry for the Late Reply,I also found the same error in my System.I rectified it by the following Steps:
    1.In the RA Application Folder u Can See These two Files
    i.COMDLG32.OCX
    ii.REFEDIT.DLL
    2.Just Copy Those two Files & Paste it in ur System
    C:\Windows\System32
    3.Restart ur System
    4.Now open Excel2007->Developer->VisualBasic->Tools-Reference->Missing XXXXXXXXX->Browse->C:\Windows\System32\COMDLG32.OCX
    5.Restart ur System

    Regards
    Anbin Ponnith
  16. 0
    Atif Ali ·
    Dear Anbin,
    Thanks a lot Anbin, really appreciated your help & it did work, although i have Excel 2003.
    I was working on a Schedule for which i have defined the Target Project & when i Backup this schedule & want to open it as INdividual Project it again Ask for Target Project. Is there any option we can Disbale the Target project requirement like any other Unique Project & it start Opne without Asking Target Project

    Regards,

    ATIF
  17. 0
    Anbin Ponnith ·
    Hai
    U Can Try This
    1.File - Open - Select The Project(XXXX)-Project Overview-Target-Delete The Target

    Regards
    Anbin Ponnith
  18. 0
    Atif Ali ·
    Thanks for reply anbin
    It working

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?