vba access to ole embedded objects in notes field

[Maurice Birchler]

Having searched high and low, it appears that vba cannot access ole objects
embedded in project notes fields.
Why I want this?
I have a routine that prints the selected tasks using bookmark locations in
word. The notes field text is also printing the task instructions, which can
be formated using rtf. I would love to be able to embed some diagrams in the
work instructions.

 

[John]

Having searched high and low, it appears that vba cannot access ole objects
embedded in project notes fields.
Why I want this?
I have a routine that prints the selected tasks using bookmark locations in
word. The notes field text is also printing the task instructions, which can
be formated using rtf. I would love to be able to embed some diagrams in the
work instructions.

Maurice,
You are right, VBA cannot access OLE objects directly in the Notes
field. You can however use cut and paste which can be partially
automated with VBA (the text must still be manually selected however).

Probably a better method is to access the Project database directly.
Take a look at the database description file (pjdb.htm or projdb.htm)
which should be somewhere on your "C" drive (mine is at: C:\Program
Files\Microsoft Office\OFFICE11\1033 for Project 2003).
I personally have never played with the Project database but I do know
there is a section specifically for accessing the RTF from the Notes
field.

Hope this helps.
John

 

[Maurice Birchler]

Thanks, unfortunately this requires the project to be saved as a database and
is not possible with *.mpp files.
Also having access to the RTF does not provide access to the embedded objects.

i think I will have to give up o this one.
Maurice