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

RA is somesort of automation linking between our application (lotus notes, access, excel ) to P3. It’s 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 Primavera’s development team, RA facilitates resource and activity control for the enterprise through an organization’s primary business applications.
----

Hi Amri,

Thanks for the info but actually I’m 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

This one I’m 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

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.

Okey, I used activity.xls. The macro’s 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 ??

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

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.