Project to Excel: group by WBS

[momcaro]

Hello,
Is there a way (macro/VBA?) to export or copy/paste data from MSProject into Excel and automatically group the tasks together as they are grouped in Project?
I have found something to export it with indents, but how do I grouped it other than manually? (I will need to do this weekly).
Thank you.
Caroline

 

[NARAYANK991]

Hi Caroline ,

Have you gone through this link ?

http://www.pmconnection.com/modules.php?name=News&file=article&sid=57

Narayan

 

[momcaro]

Thank you, but none of those accomplished what I was trying to do. I cannot save to htm/html with project 2013

 

[bobhc]

You could try this ->
You can try export from MS Project to Excel. Just hit Save As, and
select XLS as the destination file type. That will kick off the Export Wizard.

If that does not work, make some coffee get comfy and read this

http://www.pmconnection.com/modules.php?name=News&file=article&sid=60


.
ps...Best of luck

 

[momcaro]

Thank you. I am starting to think the solution is non-existent. Come on Microsoft!