Export notes to Excel and Word using VBA

[SoftwareTester]

I've been advised to post my question here after I posted it in 'MS Project
general' group

I want to export notes I added for each task from MS Project to Excel and
Word using VBA.

These notes have been copied from Word and do contain formatting info
(color, bullets and numbering, font) and I want to preserve formatting. Some
of these notes are over 255 characters.

How can I export notes from tasks preserving formatting using VBA?

 

[John]

I've been advised to post my question here after I posted it in 'MS Project
general' group

I want to export notes I added for each task from MS Project to Excel and
Word using VBA.

These notes have been copied from Word and do contain formatting info
(color, bullets and numbering, font) and I want to preserve formatting. Some
of these notes are over 255 characters.

How can I export notes from tasks preserving formatting using VBA?

SoftwareTester,
I've got the macro you want. It's very popular, over the years I've
received multiple requests for it. Just write me at the address below.
Please provide the following information in your e-mail.
1. What company do you work for?
2. What is their main product or service?
3. What do you do at the company?
4. Where are you located?
5. What version of Project are you using?
6. What version of Windows are you using?
7. What if any, is your level of expertise with Project VBA?

John
Project MVP
jensenljatatfastmaildotdotfm
(remove obvious redundancies)