Another way if you encounter that problem again is to open your P3 program before launching your Excel utilities. That should not ask you any usersname and password because btrive is already running.
There are some few examples in RA (Access/Excel/VB Code..etc) You said you try RA Excel, which Excel files did you use? (ProjectMod.xls, ActivityMod.xls, Custom.xls..etc..)
Some of them requires "dll" and "ocx" files on your system.
This one Im not understand. I just use the sample copied from the P3 CD (which consist of Access/Excel/Notes samples). and assume it supposed to run.
The excel macros stop at the code to establish the session with p3engine. Is it something wrong with my installation or bugs (p3.1 with xp with service 1)
>>Which RA excel utilities are you trying to use?
Really,what you mean by " RA Excel utilities " ? Thanks
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Tue, 2007-04-24 02:40
Thanks for the info but actually Im familiar and expert with RA utilities and its VB code. I wrote so many programs to manipulate P3 using VB and modify some of RA utilities to use another external program like MSP, Access, Visual FoxPro and Visual Basic program itself.
My question is which RA excel utilities are you trying to use? The reason I ask is to check what are the “dll” and “ocx” missing on your excel or P3 which causing you a problem.
RA is somesort of automation linking between our application (lotus notes, access, excel ) to P3. Its SDK to P3.
The sample not installed together with P3. We have to copy from the P3 disk itself.
I have tried to use ODBC, but the data only flow from P3 to excel/access only. No direct linking. If you update the excel/access data, nothing affect the P3s.
Yep, Already set my macro level to medium so that I can select which macros can run.
Will try update the btrieve using service pack.
--from google--
RA(TM), an object-oriented OLE automation server and scheduling engine. Designed for use by OEMs, ISVs, Primavera customers, and Primaveras development team, RA facilitates resource and activity control for the enterprise through an organizations primary business applications.
----
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Tue, 2007-04-24 01:23
What exactly your problems are? What RA excels utilities you’re using?
If the problem is regards to excel security then you have to set your security to medium. Select Tools-> Macro-> Security under your excel menu. Change the security level to medium. Every time you use RA excel utilities when prompted click enable macro.
Another problem that you may encounter is the username and password. It should be the default username and password when you run P3.
Last is the Btrieve. Update your Btrieve using the service pack.
Please let me know what exactly you did so I can help you further.
Member for
19 yearsRE: P3 v3.1 and RA : Not working
Amri,
Another way if you encounter that problem again is to open your P3 program before launching your Excel utilities. That should not ask you any usersname and password because btrive is already running.
Member for
23 years 10 monthsRE: P3 v3.1 and RA : Not working
Problem solved.
Old Code from CD:
It stops at this code:
bret = Session.Login(sUserName, sPassword, False) ’Login using Ra serial # one line
Rectified:
Change false to True. It works.
bret = Session.Login(sUserName, sPassword, True) ’Login using Ra serial # one line
Member for
23 years 10 monthsRE: P3 v3.1 and RA : Not working
Okey, I used activity.xls. The macros error said
Run-time error 50217 Error: Access Denied (eventough the username & password are correct).
It stops at this code:
bret = Session.Login(sUserName, sPassword, False) Login using Ra serial # one line
Amri.
p/s how to check my RA engine is installed properly and workable ??
Member for
19 yearsRE: P3 v3.1 and RA : Not working
Amri,
There are some few examples in RA (Access/Excel/VB Code..etc) You said you try RA Excel, which Excel files did you use? (ProjectMod.xls, ActivityMod.xls, Custom.xls..etc..)
Some of them requires "dll" and "ocx" files on your system.
Member for
23 years 10 monthsRE: P3 v3.1 and RA : Not working
This one Im not understand. I just use the sample copied from the P3 CD (which consist of Access/Excel/Notes samples). and assume it supposed to run.
The excel macros stop at the code to establish the session with p3engine. Is it something wrong with my installation or bugs (p3.1 with xp with service 1)
>>Which RA excel utilities are you trying to use?
Really,what you mean by " RA Excel utilities " ? Thanks
Member for
19 yearsRE: P3 v3.1 and RA : Not working
Hi Amri,
Thanks for the info but actually Im familiar and expert with RA utilities and its VB code. I wrote so many programs to manipulate P3 using VB and modify some of RA utilities to use another external program like MSP, Access, Visual FoxPro and Visual Basic program itself.
My question is which RA excel utilities are you trying to use? The reason I ask is to check what are the “dll” and “ocx” missing on your excel or P3 which causing you a problem.
Regards,
Rodel
Member for
23 years 10 monthsRE: P3 v3.1 and RA : Not working
RA is somesort of automation linking between our application (lotus notes, access, excel ) to P3. Its SDK to P3.
The sample not installed together with P3. We have to copy from the P3 disk itself.
I have tried to use ODBC, but the data only flow from P3 to excel/access only. No direct linking. If you update the excel/access data, nothing affect the P3s.
Yep, Already set my macro level to medium so that I can select which macros can run.
Will try update the btrieve using service pack.
--from google--
RA(TM), an object-oriented OLE automation server and scheduling engine. Designed for use by OEMs, ISVs, Primavera customers, and Primaveras development team, RA facilitates resource and activity control for the enterprise through an organizations primary business applications.
----
Member for
19 yearsRE: P3 v3.1 and RA : Not working
Hi Amri,
What exactly your problems are? What RA excels utilities you’re using?
If the problem is regards to excel security then you have to set your security to medium. Select Tools-> Macro-> Security under your excel menu. Change the security level to medium. Every time you use RA excel utilities when prompted click enable macro.
Another problem that you may encounter is the username and password. It should be the default username and password when you run P3.
Last is the Btrieve. Update your Btrieve using the service pack.
Please let me know what exactly you did so I can help you further.
Regards,
Rodel