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,743

Re: Bold with DDE?

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: 17,836

Re: Bold with DDE?

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
  • 269 views
  • 0 likes
  • 3 in conversation