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
Member for
16 years 4 months
Member for16 years5 months
Submitted by Anbin Ponnith on Sun, 2009-12-20 08:06
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
Member for
16 years 4 months
Member for16 years5 months
Submitted by Anbin Ponnith on Mon, 2009-12-14 01:29
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
Member for
16 years 4 months
Member for16 years5 months
Submitted by Anbin Ponnith on Wed, 2009-12-09 09:13
Member for
15 years 10 monthsRE: P3.1
Thanks for reply anbin
It working
Member for
16 years 4 monthsRE: P3.1
Hai
U Can Try This
1.File - Open - Select The Project(XXXX)-Project Overview-Target-Delete The Target
Regards
Anbin Ponnith
Member for
15 years 10 monthsRE: P3.1
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
Member for
16 years 4 monthsRE: P3.1
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
Member for
16 years 4 monthsRE: P3.1
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
Member for
16 years 4 monthsRE: P3.1
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
Member for
15 years 10 monthsRE: P3.1
Dear Anbin,
its
"Could not load an object becauz its not available on this machine"
Member for
16 years 4 monthsRE: P3.1
Dear Atif,
Could you please show which error message are you getting.So that I can sort it out.
With Thanks & Regards,
Anbin Ponnith
Member for
15 years 10 monthsRE: P3.1
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
Member for
17 years 1 monthRE: P3.1
Dear Anbin,
Thanx a lot.I got it.
Best Regards,
Santhosh
Member for
16 years 4 monthsRE: P3.1
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
Member for
17 years 1 monthRE: P3.1
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
Member for
16 years 4 monthsRE: P3.1
Dear Santhosh,
It comes along with P3 CD.Its in the folder RA Application.
Its a excel file developed with macros.
regards,
Anbin Ponnith
Member for
17 years 1 monthRE: P3.1
Dear Anbin,
Could you please elaborate upon that?
Is that a batch file?
Best Regards,
Santhosh
Member for
16 years 4 monthsRE: P3.1
Dear Santhosh,
We can get WBS description and Activity code description using RA applications. (Project .xls)
With Thanks & Regards,
Anbin Ponnith
Member for
16 years 11 monthsRE: P3.1
you r right , description have to be done manually as of i knew
Member for
17 years 1 monthRE: P3.1
Hi Shahul,
You can export Activty codes and WBS ,but iam talking about activity code description and WBS description.
Member for
16 years 11 monthsRE: P3.1
Hi
You could do it that option is available in export