jigar1276
08-24-2017, 02:34 AM
Hello,
I have a following string in one cell:
<p1:Project_Purpose xmlns:p1="http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-08-25T10:33:10"><div xmlns="http://www.w3.org/1999/xhtml"><div><font face="comic sans ms">This is the purpose of the project</font></div><div><font face="comic sans ms">rich text data to test 21-08-2017</font></div><div><p>R<u><font color="#336600">ichtext 22-08-2017</font></u></p><p><u><font color="#336600">ffsdfdsfsdf sdfsdf</font></u></p><p> </p><p>f<font size="5">s<span style="background-color: rgb(204, 0, 153);">dfsfsdf</span></font></p></div><div><div><font face="helvetica">This is the purpose of the project</font></div><div><font face="helvetica">rich text data to test 21-08-2017</font></div><div><div><font face="comic sans ms"><br/></font></div><div><font face="verdana">This is the purpose of the project</font></div><div><font face="verdana">rich text data to test 21-08-2017</font></div><div><div><font face="comic sans ms"><br/></font></div><div><font face="georgia">This is the purpose of the project</font></div><div><font face="georgia">rich text data to test 21-08-2017</font></div><div><font face="comic sans ms"><p> </p></font><p><font face="comic sans ms"> asdasdasdas asdas asdasdas</font></p><p><font face="comic sans ms">adas</font></p><p><font face="comic sans ms">das</font></p><p><font face="comic sans ms">d asas</font></p></div></div><div><font face="comic sans ms"><p> </p></font><p><font face="comic sans ms"> </font></p></div></div><div><font face="comic sans ms"><p> </p></font><p><font face="comic sans ms"> </font></p></div></div></div></p1:Project_Purpose>
This is nothing but the RTF format for following:
20165
I want vba code to read the rtf string and give me the actual look (i.e. fonts, colors, styles etc.) in other cell.
Thanks in advance,
Jigar
I have a following string in one cell:
<p1:Project_Purpose xmlns:p1="http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-08-25T10:33:10"><div xmlns="http://www.w3.org/1999/xhtml"><div><font face="comic sans ms">This is the purpose of the project</font></div><div><font face="comic sans ms">rich text data to test 21-08-2017</font></div><div><p>R<u><font color="#336600">ichtext 22-08-2017</font></u></p><p><u><font color="#336600">ffsdfdsfsdf sdfsdf</font></u></p><p> </p><p>f<font size="5">s<span style="background-color: rgb(204, 0, 153);">dfsfsdf</span></font></p></div><div><div><font face="helvetica">This is the purpose of the project</font></div><div><font face="helvetica">rich text data to test 21-08-2017</font></div><div><div><font face="comic sans ms"><br/></font></div><div><font face="verdana">This is the purpose of the project</font></div><div><font face="verdana">rich text data to test 21-08-2017</font></div><div><div><font face="comic sans ms"><br/></font></div><div><font face="georgia">This is the purpose of the project</font></div><div><font face="georgia">rich text data to test 21-08-2017</font></div><div><font face="comic sans ms"><p> </p></font><p><font face="comic sans ms"> asdasdasdas asdas asdasdas</font></p><p><font face="comic sans ms">adas</font></p><p><font face="comic sans ms">das</font></p><p><font face="comic sans ms">d asas</font></p></div></div><div><font face="comic sans ms"><p> </p></font><p><font face="comic sans ms"> </font></p></div></div><div><font face="comic sans ms"><p> </p></font><p><font face="comic sans ms"> </font></p></div></div></div></p1:Project_Purpose>
This is nothing but the RTF format for following:
20165
I want vba code to read the rtf string and give me the actual look (i.e. fonts, colors, styles etc.) in other cell.
Thanks in advance,
Jigar