TASK_RTF_NOTES in Project 2003 Professional

[Curmudgeon]

Is there a way I can retrieve the contents of TASK_RTF_NOTES from a
Proj03 Professional mpp file using VBA in Access? If I open the mpp as
an object in VBA and attempt to access the TASK_RTF_NOTES field using
something like T.TASK_RTF_NOTES I get an error.

For testing purposes I have saved the mpp to an mdb and verified that
TASK_RTF_FIELDS is present and populated in MSP_TASKS, but I need to
access it directly from Access programmatically.

If I can figure out how to access it, where can I find code that will
help me convert the long binary data to a string?

Thanks
Dave

 

[JulieS]

Hi Dave,

Find the file PJDB.HTM at the installation point for Project. There
is some VB script that pulls the RTF data from the notes field.
Search for the topic "Reading and writing RTF notes".


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project



"Curmudgeon" wrote in message
news:e9fa8b9e-60d6-46e9-869d-5d1366d677d3@g17g2000prg.googlegroups.com...