Export notes to Excel and Word using VBA

[SoftwareTester]

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?

 

[DenisB]

I can help you with that.
If you open your project on my www.amiproject.com website, and send me
a link on that (File/Share, I can extract notes for you to Excel with
RTF formatting and no limits on size.

 

[SoftwareTester]

Thanks for the offer, but what I really want is doing it myself in VBA as I
want to generate Excel sheets (and sometimes a Word document) from within MS
Project frequently.
So I would like to make a VBA-subroutine for that

Can you (will you) help me on that?

 

[Rob Schneider]

Dennis,

Off hand I don't remember the details of how to do this. But as this
involves VBA best to re-ask on the newsgroup which focuses on VBA
microsoft.public.project.developer which is where the gurus hangout.

I also have a hunch this has been previously covered in the newsgroup,
so perhaps you can search the older postings and get an answer now
rather than waiting for someone to pick this up.

--rms

www.rmschneider.com