<div>
You will have to do it following way:<br />
1. Get IDispatch of Excel to request latter interface which allows you to modify specific cell<br />
2. Set text<br />
3. Set font<br />
<br />
See in MSDN &quot;HOWTO: Automate Linked and Embedded ActiveX Documents&quot;<br />
ID: Q193039 <br />
<br />
This artical shows how to do it.<br />

</div>


You will have to do it following way:
1. Get IDispatch of Excel to request latter interface which allows you to modify specific cell
2. Set text
3. Set font

See in MSDN "HOWTO: Automate Linked and Embedded ActiveX Documents"
ID: Q193039

This artical shows how to do it.


<div>
<div class="content wysiwyg-content">
Hi all,<br />
Do you know how to easily exporting a formatted string to a cell in Excel97 via OLE?<br />
<br />
By formatted string I mean:<br />
- specified the Font used for the string: name, size, bold &amp;&nbsp;italic<br />
- color of the string (e.g. red, yellow, etc...)<br />
E.g: sending to a specific cell of Excel the string &quot;This is a test&quot;,<br />
with font &quot;Comics&quot;, Size 16, Bold, and in red color ?<br />
<br />
TIA<br />
David.<br />
<br />

</div>
</div>


Hi all,
Do you know how to easily exporting a formatted string to a cell in Excel97 via OLE?

By formatted string I mean:
- specified the Font used for the string: name, size, bold & italic
- color of the string (e.g. red, yellow, etc...)
E.g: sending to a specific cell of Excel the string "This is a test",
with font "Comics", Size 16, Bold, and in red color ?

TIA
David.



How to send formatted string to Excel via automation???

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.