Convert P3 to excel File.

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

Hi Christopher,

the explanation of Paul is very good, maybe in simple words:

- ra is available after installing P3

- ra is a group of elements(functions etc.) to write a VBA-macro in Excel (or Access) in order to read from or write into the database of P3.

- some examples are available on the P3-CD, but they are quit complicated. Some years ago I wrote a very simple macro and posted it in this forum. Maybe you can find it, otherwise I will repost it

- Look for ra.hlp on your installation CD



DBF is an old format, quit simple, first a header with information about the data, followed by ascii-delimited data



Excel could read it, newest versions cannot write it anymore



Regards Hannes

"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

The simplest methid is to display the columns of data and copy and paste, one of the few things you can not get out is the leads and lags, so you will need to export using say dbf format and open with Excel. Resource data may be exported by organising by resource.



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