Exporting into Excel

[Mark Vandneberk]

I am trying to Export a Project File into Excel. I can get
all the data that I would like into excel however, it's
just one big long list. Very difficult to do anything with.

Is there any option that allows you to indent or group the
tasks just like in Project? Is there an option that allows
you to also copy the calendar/gantt chart w/ the timelines?

Any input would be appreciated.

Thanks

 

[JulieD]

Hi Mark

for your first question check out
export hierarchy to excel macro at Jack Dahlgren's (excellent & extremely
useful) website
http://masamiki.com/project/macros.htm

not sure on the second question - maybe someone else can help there

Cheers
JulieD

 

[John]

Mark,
In answer to your second question there is not an option per se for
copying gantt chart graphic information. However there are several ways
to get there. One way, although I've never tried it, is to save the
gantt chart view as a web page. I'm not sure exactly what it does with
the graphic, but you might want to read about it in the Project help
file and give it a try.

A second method that is often used is to capture the gantt chart view as
an image using the 'copy picture' (little camera) icon. With this method
you have to try different screen formats to get the image as you want it.

Another method, if you have the full Adobe Acrobat version, is to save
the file as a .pdf. You won't be able to manipulate it but the whole
file is captured.

Yet another method is to use a VBA macro to effectively replicate the
graphic features of each task in the Gantt Chart. This method can be
used in Excel, PowerPoint, or Word. It does give you control of the
image, but requires some VBA expertise.

Hope this helps.
John