VBA. Получение содержимого заметок к задаче в формате RTF

%3CLINGO-SUB%20id%3D%22lingo-sub-2689843%22%20slang%3D%22en-US%22%3EVBA.%20%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D0%B5%20%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B8%D0%BC%D0%BE%D0%B3%D0%BE%20%D0%B7%D0%B0%D0%BC%D0%B5%D1%82%D0%BE%D0%BA%20%D0%BA%20%D0%B7%D0%B0%D0%B4%D0%B0%D1%87%D0%B5%20%D0%B2%20%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B5%20RTF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2689843%22%20slang%3D%22en-US%22%3E%3CP%3E%D0%9A%D0%BE%D0%BB%D0%BB%D0%B5%D0%B3%D0%B8!%3C%2FP%3E%3CP%3E%D0%94%D0%BE%D0%B1%D1%80%D1%8B%D0%B9%20%D0%B4%D0%B5%D0%BD%D1%8C!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%D0%9F%D0%BE%D0%B4%D1%81%D0%BA%D0%B0%D0%B6%D0%B8%D1%82%D0%B5%2C%20%D0%BA%D0%B0%D0%BA%20%D0%B2%20%D0%BA%D0%BE%D0%B4%D0%B5%20VBA%20%D0%BC%D0%BE%D0%B6%D0%BD%D0%BE%20%D0%BF%D0%BE%D0%BB%D1%83%D1%87%D0%B8%D1%82%D1%8C%26nbsp%3B%3C%2FFONT%3E%3CFONT%3E%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B8%D0%BC%D0%BE%D0%B5%20%D0%B7%D0%B0%D0%BC%D0%B5%D1%82%D0%BE%D0%BA%20%D0%BA%20%D0%B7%D0%B0%D0%B4%D0%B0%D1%87%D0%B5%20%D0%B2%20%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B5%20RTF%2C%20%D1%82.%D0%B5.%20%D1%81%20%D1%83%D1%87%D0%B5%D1%82%D0%BE%D0%BC%20%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F%20%D0%B8%20%D0%B2%D0%BD%D0%B5%D0%B4%D1%80%D0%B5%D0%BD%D0%BD%D1%8B%D1%85%20%D0%BE%D0%B1%D1%8A%D0%B5%D0%BA%D1%82%D0%BE%D0%B2%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E*%20%D0%A4%D0%B0%D0%B9%D0%BB%20%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B0%20MPP%2C%20MS%20Project%202016.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2690118%22%20slang%3D%22en-US%22%3ERe%3A%20VBA.%20%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D0%B5%20%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B8%D0%BC%D0%BE%D0%B3%D0%BE%20%D0%B7%D0%B0%D0%BC%D0%B5%D1%82%D0%BE%D0%BA%20%D0%BA%20%D0%B7%D0%B0%D0%B4%D0%B0%D1%87%D0%B5%20%D0%B2%20%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B5%20RTF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2690118%22%20slang%3D%22en-US%22%3EOld%20Mike%20--%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20an%20English%20language%20user%20forum.%20Please%20repost%20your%20question%20in%20English%20and%20we%20will%20try%20to%20help%20you.%20Thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2690370%22%20slang%3D%22en-US%22%3ERe%3A%20VBA.%20%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D0%B5%20%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B8%D0%BC%D0%BE%D0%B3%D0%BE%20%D0%B7%D0%B0%D0%BC%D0%B5%D1%82%D0%BE%D0%BA%20%D0%BA%20%D0%B7%D0%B0%D0%B4%D0%B0%D1%87%D0%B5%20%D0%B2%20%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B5%20RTF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2690370%22%20slang%3D%22en-US%22%3EFor%20reference%2C%20here's%20the%20translation%3A%3CBR%20%2F%3EColleagues!%3CBR%20%2F%3E%3CBR%20%2F%3EGood%20day!%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ETell%20me%20how%20in%20VBA%20code%20you%20can%20get%20the%20content%20of%20notes%20to%20a%20task%20in%20RTF%20format%2C%20i.e.%20considering%20formatting%20and%20embedded%20objects%3F%3CBR%20%2F%3E%3CBR%20%2F%3E*%20MPP%20file%2C%20MS%20Project%202016%3CBR%20%2F%3E%3CBR%20%2F%3ENow%2C%20I%20have%20a%20question%20for%20you%20and%20please%20respond%20in%20English%20so%20I%20don't%20have%20to%20use%20the%20Google%20language%20translator.%20What%20exactly%20are%20you%20trying%20to%20do%3F%20And%20for%20reference%2C%20Project%20VBA%20does%20NOT%20have%20the%20capability%20to%20extract%20formatting.%3CBR%20%2F%3EJohn%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2691259%22%20slang%3D%22en-US%22%3ERe%3A%20VBA.%20%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D0%B5%20%D1%81%D0%BE%D0%B4%D0%B5%D1%80%D0%B6%D0%B8%D0%BC%D0%BE%D0%B3%D0%BE%20%D0%B7%D0%B0%D0%BC%D0%B5%D1%82%D0%BE%D0%BA%20%D0%BA%20%D0%B7%D0%B0%D0%B4%D0%B0%D1%87%D0%B5%20%D0%B2%20%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%82%D0%B5%20RTF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2691259%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20translated%20the%20question%20in%20English%20with%20the%20help%20of%20a%20Google%20language%20translator%3A%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20tell%20me%2C%20how%20in%20the%20VBA%20code%20to%20get%20the%20contents%20of%20notes%20to%20the%20task%20in%20RTF%20format%2C%20i.e.%20taking%20into%20account%20formatting%20and%20embedded%20objects%3F%3CBR%20%2F%3E%3CBR%20%2F%3E*%20MPP%20file%20format%2C%20MS%20Project%202016%2C%20maybe%20there%20are%20third-party%20libraries%20that%20can%20do%20this%20and%20that%20can%20be%20used%20in%20VBA.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Коллеги!

Добрый день!

 

Подскажите, как в коде VBA можно получить содержимое заметок к задаче в формате RTF, т.е. с учетом форматирования и внедренных объектов?

* Файл формата MPP, MS Project 2016.

7 Replies
Old Mike --

This is an English language user forum. Please repost your question in English and we will try to help you. Thank you.
For reference, here's the translation:
Colleagues!

Good day!



Tell me how in VBA code you can get the content of notes to a task in RTF format, i.e. considering formatting and embedded objects?

* MPP file, MS Project 2016

Now, I have a question for you and please respond in English so I don't have to use the Google language translator. What exactly are you trying to do? And for reference, Project VBA does NOT have the capability to extract formatting.
John

Good day!

I translated the question in English with the help of a Google language translator:

Can you tell me, how in the VBA code to get the contents of notes to the task in RTF format, i.e. taking into account formatting and embedded objects?

* MPP file format, MS Project 2016, maybe there are third-party libraries that can do this and that can be used in VBA.

Thanks

OldMike,
You see I already translated your question and also already provided the answer. Unfortunately the answer is you can NOT extract Notes field formatting with VBA.
John
Thank you for your answer, John!

Can you give me advice, how to extract and write formatted notes to an MPP file in another way. From your point of view, is there such a possibility?

* The fact is that, I programmatically (VBA, Task (...). Notes) make changes to notes and after that the formatting is removed. I would like to fix this.

Thanks.
OldMIke,
As far as I know there is no way to retain or capture Notes field formatting. Several years ago I faced the same issue and after talking to a contact at Microsoft I found out the notes text string is saved in more than one place in Project's underlying database, however when using VBA to capture the notes text, the un-formatted text string is what is captured.

It may be possible to use an API (or some other query) to get the formatted notes string out of Project's database but I have no idea how to do that.

John
Thank you again!
I will "dig" further, if I find it, I will write (I hope, I will not forget).