Skip to content

P3 RA - Automation Engine

Ray MessingerMember for 25 years 6 months
Created
13
3
0
There have been many posts concerning the importing and exporting of P3 data to other applications for data entry, analysis or reporting. I have tried using the import/export function in P3, batch and ODBC. But what I am using most now is RA, the automating engine. It provides more power and flexability though it does require more programming skill.

Using RA I have written VBA/VBS macros that can create new schedules, add and update activities, add resource loading, run the CPM, run reports, interoperate other applications and more.

In responce to the post concerning loading BQ resources values I wrote an Excel/RA macro that creates the Activity/BQ matrix from P3. The values can then be edited and then re-loaded back into P3 with just a click.

If there are other P3 users interested I will upload the file somewhere. I dont want to be emailing it individually.
Is there a common file site associated with Planning Planet that can be used to exchange files?

You must have installed P3 RA on your computer for these macros to work.

13 replies

Oldest first
  1. 0
    Ray Messinger ·
    I have setup a page to share the RA macros I wrote. It is at: http://www.geocities.com/miraray/tech/tech.html There are some interesting utilities. One can be used to automatically update a progress graphic (map, schematic, etc). Some interface with Milestone Professional for summary presentation schedules. [moderator edit]I changed the URL to a live link...[/moderator edit]
  2. 0
    Sankar Madhavan Pillai ·
    Could you please email me ur Ra scripts.It is interesting
  3. 0
    Adjie Heryanto ·
    Ray,

    Can I have copy of your macros ?
    Are they all based on Excel ?

    Adjie - Jakarta
  4. 0
    Ray Messinger ·
    They are still at the link mentioned below. They are in Excel VBA/VBScript but could use any VBA client.

  5. 0
    Mk Tse ·
    Does anyone have the VBA on RA for Access 2000 version?
  6. 0
    Ray Messinger ·
    The RA OLE aqutomation functions and commands would be the same. There are also examples on Primavera’s RA page.
  7. 0
    Mk Tse ·
    The available Access VBA on CD is in version97 and cannot converted to version2000 automatically. Microsoft have changed the sytem and some command is no longer valid. For Excel, since the command is compatible in both version 97 and 2000, no problem at all.
  8. 0
    Forum Guest ·
    Hi Ray,

    Can you plese include also the excel sheet for cost loading

    Thanks
  9. 0
    Alfon Lyndon Joson ·
    Ray...

    i think its quiet convenient enough if you modify the "resource loading", making the Activities in "Rows (Horizontal Oriented)" and the Resources in "Columns(Vertical Oriented)" just like what jorge taguinod have done...

    best regards...

    ALFON
    SCDC
  10. 0
    Amri Mansor ·
    How to install the P3 RA - Automation Engine properly?? I’ve copy the sample but the IT guy installed the Primavera P 3.1 running on XP machine for me.

    Macros can’t establish/stop at establishing the session .?

    Anything wrong somewhere??

    Thanks
  11. 0
    Mark Chapman ·
    I am coming in from the cold.. can someone explain what RA is pls?
  12. 0
    Mark Chapman ·
    Amri wrote in another post the answer:

    --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.
  13. 0
    Mohammad A ·

    Dear Ray and Moderator, I

    Dear Ray and Moderator,

    I cant find the updated link. Can you please put the updated link once again.

    Regards

    Rumi

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?