Maintain format when exporting Project to Excel

[Smeac81]

After successfully exporting Project (MS Project Online Desktop Client v2403) to Excel (MS 365 Apps for Business v2403) using the Export tool, all of the data is present but the format has been simplified.  The Tasks are no longer indented from the Summaries making it difficult to follow the flow of the project.  The Summaries in Project are bold but in the Excel export, the bold feature is gone.  Any way to maintain the formatting that Project has in the Excel export?  I can fix it manually but with 500+ line itmes, that is a chore.

[#2 · Accepted solution]

@Smeac81 

Yeah, I've got what you want/need and it is a macro I wrote a few years ago.

If you are interested, contact me at the address below.

John

jmacprojataticlouddotdotcom

(remove obvious redundancies)