Export project to excel

[Walrus]

Hi all,

I want project data to be exported to a excel file but ....
There are 3 outlines (task levels) and i want those
combined.
In project:
Ountline1
Ountline2
Outline3_1
Outline3_2
Outline3_3

Export to excel:
Outline1, Outline2, Outline3_1
Outline1, Outline2, Outline3_2
Outline1, Outline2, Outline3_3
Does anyone of you have an idea/solution for this problem?

Thanks in advance for your help.

 

[Jan De Messemaeker]

Hi Walrus,

1. You can export to excel as usual, but also export the field Outline
level: this would allow you to program what you want in Excel

2. You could make this concatenation in Project VBA or Excel VBA.

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Gérard DUCOURET]

Hi Walrus,

I think that before to export your data to Excel, you have to populate a custom field like Text1
with your outline numbers.
Underwith is an example of a VBA procedure that you could adapt for that job.
Hope this help,

Gérard Ducouret

Sub Parent_enfants()
Dim oTâche As Object
For Each oTâche In ActiveProject.Tasks
If oTâche.Summary = False Then
oTâche.Text10 = oTâche.OutlineParent.Name
End If
Next oTâche
End Sub

 

[Jack D.]

Walrus,

Look at two macros on my website.
http://masamiki.com/project/macros.htm
The first is the summaryname macro which stores all of the parent names.
The second is the export heirarchy to excel macro which shows you how to
format the output to excel.
Working with those two you should be able to achieve what you want.

-Jack

Hi Walrus,

I think that before to export your data to Excel, you have to populate a
custom field like Text1 with your outline numbers.
Underwith is an example of a VBA procedure that you could adapt for that
job.
Hope this help,

Gérard Ducouret

Sub Parent_enfants()
Dim oTâche As Object
For Each oTâche In ActiveProject.Tasks
If oTâche.Summary = False Then
oTâche.Text10 = oTâche.OutlineParent.Name
End If
Next oTâche
End Sub

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently.
For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++

 

[Walrus]

Gerard,

Thanks for your answer, but.....
Unfortenately it doesn't work.

Any suggestions?

Thanks in advance

-----Original Message-----
Hi Walrus,

I think that before to export your data to Excel, you

have to populate a custom field like Text1

 

[Walrus]

Jan,

Thanks for the reply.
But.. how to in VBA?

Thanks in advance

 

[Jan De Messemaeker]

I think you should have a look at Jack's macros.
Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620