Forum Discussion
Convert MPP into Excel file with transposition of every stage of sub-tasks in successive columns
Dear All, I hope you are doing well and it's my first time ever in Microsoft forum As explained in the subject title, I want to know if it's possible to convert MPP file into Excel file addin...
Cashflowlimited,
Welcome to the forum. To answer your question, "yes" that can be done (either Excel format). There are at least two ways to do it. One, is tedious but effective and that is a copy and paste. The other is via VBA.
I don't quite follow your, "file ready to share [with emoji]" though. I personally think the first format is more readable. How about replication of the Project Task Sheet view, including outline level indents, in Excel? I already have a macro that does that.
John
Welcome to the forum. To answer your question, "yes" that can be done (either Excel format). There are at least two ways to do it. One, is tedious but effective and that is a copy and paste. The other is via VBA.
I don't quite follow your, "file ready to share [with emoji]" though. I personally think the first format is more readable. How about replication of the Project Task Sheet view, including outline level indents, in Excel? I already have a macro that does that.
John
Hi John,
Thanks for your quick feedback
By "file ready to share", I meant the second view I represented is my final target
But if I can get the first proposal (that is more readable), then I can modify it manually after all
You want me the share the whole project ? Or I can get macro you already created with some explanations ?
Sorry I'm not english native
Kind regards
- Cashflowlimited,
You're welcome and thanks for the feedback. If you are able and willing to share your file, that would be helpful. Then I can test the macro and make sure it works for you.
You can send me the file via e-mail to the address below. I will ask some questions.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies)- Hi John,
Done right now by e-mail
Kind regards