How to setup a column containing the summary name for each task?

I want to insert a new column that contains the summary name of each task
Therefore I can export the column to an excell spreadsheet that has the name
of a task, the resource name and the summary task all on ONE row.

Steve
Mon Jun 06 08:52:26 CDT 2005

AFAIK there's no way to do that, sorry.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

"ellebelle" <ellebelle@discussions.microsoft.com> wrote in message
news:EDB32313-FC80-471D-AC8F-518ED6B108A3@microsoft.com...
>I want to insert a new column that contains the summary name of each task
> Therefore I can export the column to an excell spreadsheet that has the
> name
> of a task, the resource name and the summary task all on ONE row.
>
>

davegb
Mon Jun 06 10:34:20 CDT 2005


Sorry to disagree with you, Steve, but I think this could be done using
by putting the summary task name in a custom text field. If there are a
lot of tasks in the Project, it would require a lot of time or a VBA
macro.

Steve House [Project MVP] wrote:
> AFAIK there's no way to do that, sorry.
>
> --
> Steve House [MVP]
> MS Project Trainer & Consultant
> Visit http://www.mvps.org/project/faqs.htm for the FAQs
>
> "ellebelle" <ellebelle@discussions.microsoft.com> wrote in message
> news:EDB32313-FC80-471D-AC8F-518ED6B108A3@microsoft.com...
> >I want to insert a new column that contains the summary name of each task
> > Therefore I can export the column to an excell spreadsheet that has the
> > name
> > of a task, the resource name and the summary task all on ONE row.
> >
> >

ellebelle
Mon Jun 06 11:28:01 CDT 2005

when you are in Gant Chart View you are not given teh option to incllude a
Summary Task Name in a custom text field.

You can do this if you are in the 'resource usage' view, however then you
will get the resource name in hte same column as the task name and you are
back where you started.

I want one row with the resource name. task name and sumary name on it.

Jan
Mon Jun 06 12:53:38 CDT 2005

Hi,

The VBA macro youneed is quite simpel:

Sub SummName
dim job as task
for each job in activeproject.tasks
if not job is nothing then
if not job.outlinelevel=1 then
job.text7=job.outlineparent.name
end if
end if
next jopb
end sub

HTH




--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"ellebelle" <ellebelle@discussions.microsoft.com> schreef in bericht
news:EDB32313-FC80-471D-AC8F-518ED6B108A3@microsoft.com...
> I want to insert a new column that contains the summary name of each task
> Therefore I can export the column to an excell spreadsheet that has the
name
> of a task, the resource name and the summary task all on ONE row.
>
>

ellebelle
Thu Jun 09 12:07:07 CDT 2005

It worked! Thanks a lot.....

"Jan De Messemaeker" wrote:

> Hi,
>
> The VBA macro youneed is quite simpel:
>
> Sub SummName
> dim job as task
> for each job in activeproject.tasks
> if not job is nothing then
> if not job.outlinelevel=1 then
> job.text7=job.outlineparent.name
> end if
> end if
> next jopb
> end sub
>
> HTH
>
>
>
>
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> http://users.online.be/prom-ade/
> +32-495-300 620
> "ellebelle" <ellebelle@discussions.microsoft.com> schreef in bericht
> news:EDB32313-FC80-471D-AC8F-518ED6B108A3@microsoft.com...
> > I want to insert a new column that contains the summary name of each task
> > Therefore I can export the column to an excell spreadsheet that has the
> name
> > of a task, the resource name and the summary task all on ONE row.
> >
> >
>
>
>

Jan
Thu Jun 09 12:25:02 CDT 2005

You're welcome.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"ellebelle" <ellebelle@discussions.microsoft.com> schreef in bericht
news:93F69E0E-85A9-46D7-BBE1-F036A196546D@microsoft.com...
> It worked! Thanks a lot.....
>
> "Jan De Messemaeker" wrote:
>
> > Hi,
> >
> > The VBA macro youneed is quite simpel:
> >
> > Sub SummName
> > dim job as task
> > for each job in activeproject.tasks
> > if not job is nothing then
> > if not job.outlinelevel=1 then
> > job.text7=job.outlineparent.name
> > end if
> > end if
> > next jopb
> > end sub
> >
> > HTH
> >
> >
> >
> >
> > --
> > Jan De Messemaeker
> > Microsoft Project Most Valuable Professional
> > http://users.online.be/prom-ade/
> > +32-495-300 620
> > "ellebelle" <ellebelle@discussions.microsoft.com> schreef in bericht
> > news:EDB32313-FC80-471D-AC8F-518ED6B108A3@microsoft.com...
> > > I want to insert a new column that contains the summary name of each
task
> > > Therefore I can export the column to an excell spreadsheet that has
the
> > name
> > > of a task, the resource name and the summary task all on ONE row.
> > >
> > >
> >
> >
> >