Prev: Project Ver - Can Project 2003 Pro and Std. Work on a Shared
Next: when I add resources my durations don't change - Why?
From: GuitrDad on 30 Apr 2008 10:13
I see that '07 eliminated what I consider to be key functionality for
exporting and analyzing resource data in Excel. Help suggests utilizing
reports (canned or custom). Am I missing where you can export this data to
Excel (short of cutting and pasting from the screen)?

Thanks.
Joe
From: Jack Dahlgren on 30 Apr 2008 10:45
I put together a macro to do this.
You can find it here:

http://zo-d.com/blog

-Jack Dahlgren

"GuitrDad" <GuitrDad(a)discussions.microsoft.com> wrote in message
news:0D4CB758-4B62-4F91-A8B0-24F81DD71DDE(a)microsoft.com...
>I see that '07 eliminated what I consider to be key functionality for
> exporting and analyzing resource data in Excel. Help suggests utilizing
> reports (canned or custom). Am I missing where you can export this data
> to
> Excel (short of cutting and pasting from the screen)?
>
> Thanks.
> Joe


From: Chander Mohan Saini on 1 May 2008 08:07
File > Save As > Save As Type (below file name) > Select 'Microsoft Excel
work book > Save. A wizard will open, select Project Excel Template (or other
option as per your requirements) > Finish. Excel file is saved, check where
it is saved, file name can also be changed while saving.

"GuitrDad" wrote:

> I see that '07 eliminated what I consider to be key functionality for
> exporting and analyzing resource data in Excel. Help suggests utilizing
> reports (canned or custom). Am I missing where you can export this data to
> Excel (short of cutting and pasting from the screen)?
>
> Thanks.
> Joe
 | 
Pages: 1
Prev: Project Ver - Can Project 2003 Pro and Std. Work on a Shared
Next: when I add resources my durations don't change - Why?