DATA Step, Macro, Functions and more

Bold with DDE?

Reply
N/A
Posts: 0

Bold with DDE?

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
SAS Super FREQ
Posts: 8,868

Re: Bold with DDE?

Posted in reply to deleted_user
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
Super User
Posts: 19,850

Re: Bold with DDE?

Posted in reply to deleted_user
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]
N/A
Posts: 0

Re: Bold with DDE?

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

Jeff
Ask a Question
Discussion stats
  • 3 replies
  • 279 views
  • 0 likes
  • 3 in conversation