Bringing Bullets from Notes to Excel

[roadkill]

To maintain the readability of text in the task Notes field, I want to
include any bullets when I copy these notes over to Excel (programmatically).
I detect no special characters (other than LF) when I interrogate the Notes
field information as a string. Obviously MS Project knows where the bullets
are. How do I get it to divulge this information?

Thank you,
Will

 

[John]

To maintain the readability of text in the task Notes field, I want to
include any bullets when I copy these notes over to Excel (programmatically).
I detect no special characters (other than LF) when I interrogate the Notes
field information as a string. Obviously MS Project knows where the bullets
are. How do I get it to divulge this information?

Thank you,
Will

Will,
Some time back I worked on this issue for many hours without success. At
first I thought maybe it was just a unicode character and that if I
checked for it, things would work, but to no avail. After further
checking with other folks I found out that text can be stored in many
ways, and however the bullet formatting is stored for the Project Notes
field, it is not readily accessible through VBA. What I finally ended up
doing is carefully detecting the line feeds and then formatting the text
in Excel accordingly.

There's probably a way to do it, but I haven't found it.

John
Project MVP