Hi Christopher

here teh small example

make a macro out of it in Excel:

Dim session As Object
Dim proj As Object
Dim act As Object
Dim res_id As Object
Dim succes As Object
Dim bret As Boolean
Dim username, password, projectname As String
Dim xRow, ActNos As Integer
Dim sheet As Workbooks

Sub Primavera()
Set session = CreateObject("P3Session")
username = Application.InputBox("Please enter Username:", "login", "xxx")
password = ""
bret = session.Login(username, password, True)

Worksheets("Sheet1").Cells(1, 1).Value = "ActivityID"
Worksheets("Sheet1").Cells(1, 2).Value = "Description"
Worksheets("Sheet1").Cells(1, 3).Value = "Resource"
Worksheets("Sheet1").Cells(1, 4).Value = "BudgetedCost"
Worksheets("Sheet1").Cells(1, 5).Value = "BudgetedQuantity"
projectname = Application.InputBox("Please enter ProjectName:", "project", "yyyy")
Set proj = session.openproject(projectname, 0, 99)
xRow = 2
ActNos = 1
For Each act In proj.activities
Worksheets("P3-Resources").Cells(xRow, 1).Value = act.ActivityID
Worksheets("P3-Resources").Cells(xRow, 2).Value = act.Description
For Each res_id In act.ResourceAssignments
Worksheets("Sheet1").Cells(xRow, 3).Value = res_id.ResourceName
Worksheets("Sheet1").Cells(xRow, 4).Value = res_id.BudgetedCost
Worksheets("Sheet1").Cells(xRow, 5).Value = res_id.BudgetedQuantity
xRow = xRow + 1
Next
ActNos = nos + 1
Application.StatusBar = ("Activity: " & xRow)
Next

session.closeproject proj
End Sub

"The RA automation server grants access to all of P3’s advanced scheduling, leveling, cost calculations, resource data, and activity data through an
object-oriented automation layer based on the OLE 2.0 specification. RA offers the flexibility and power to customize existing tasks, link existing applications,
and build entirely new applications around P3’s functionality. RA enables you to work with P3’s project management functions, business processes, and
project data using any OLE-compliant development tool.
RA offers a major advantage over direct Open Database Connectivity (ODBC) access: RA adheres to P3 business rules. By writing to the RA API, the
underlying database is not a concern of the application builder. In contrast, by using direct links the developer would need to write different interfaces to
accommodate the different underlying databases.

By using the RA software developers kit (SDK), programmers can access and manipulate project data with standard programming tools such as Visual
Basic, Visual C++, and SoftBridge Basic Language (SBL). SBL is included on the RA CD-ROM (Compact Disc-Read Only Memory). RA will also work with
applications such as Microsoft Access and Excel through Visual Basic for Applications (VBA)."

The text above was copied from the Ra help file.

dbf is an old database format that may be exported by P3 and opened with Excel.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers, Consulting and Training
www.eh.com.au
www.primavera.com.au

Hi Christopher

a very nice method is using Ra, it has VBA like Excel, so you can read and write in both directions