Export data to MS Excel

[MSPLearner]

So here's a problem I am interested solving. Maybe you have an easy/obvious
answer.

Using either a pivot table Excel export or VBA (a less preferable option),
can you create PER DAY WORK EFFORT record (in Excel) that would be formatted
as follows.

For each MSP Project Task as follows:

Task Name Start Finish Work
Install Software 06/28/2007 04/03/2007 32 hours

generate the following output record (for Excel) -

Task Name Day Work

Install Software 06/28/2007 8
Install Software 06/29/2007 8

Install Software 07/02/2007 8
Install Software 07/03/2007 8

Thanks in advance

 

[Jan De Messemaeker]

Hi,

I don't know Excel well enough to discuss pivot tables but in VBA it's no
problem at all.