Bold with DDE?

[deleted_user]

I'm using DDE to export data to a spreadsheet. Everything is working fine but I need to bold certain entries on the fly. Is there a way to use Escapechar? Something else?

Jeff

[Cynthia_sas]

Hi:
DDE is NOT using ODS. So, you'd have to use Microsoft commands to select your cells and perform your bolding -- I'm not sure what DDE/Microsoft command would be the equivalent of clicking on the 'B' button on the Excel ribbon.

ODS ESCAPECHAR techniques would only work with ODS output, such as that created by ODS HTML, ODS MSOFFICE2K or ODS TAGSETS.EXCELXP when you create HTML or XML files to be opened with Excel.

cynthia

[Reeza]

You can do it using the font.properties command, see paper 022-31 by Bessler on DDE.


[pre]
data _null_;
File DDEcmds;

put '[select("R5C3:R7C5")]';
put '[font.properties("Verdana","Bold Italic",16,,,,,,,3)]';

run;
[/pre]

[deleted_user]

Thanks Reeza, that's a great article. I was able to solve the problem with font.properties.

Jeff