DATA Step, Macro, Functions and more

text formating Excel cell with dde

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

text formating Excel cell with dde

Hello,

 

How to text format a cell using dde?

 

Thank you.


Accepted Solutions
Solution
‎04-12-2017 09:35 AM
Occasional Contributor
Posts: 7

Re: text formating Excel cell with dde

Hello,

 

For those who are in the same situation, here is the solution:

filename xlappli dde "excel|system";
data _null_;
file xlappli;
PUT "[SELECT(""R1C1:R1C1"")]" ;
PUT "[FORMAT.NUMBER(""@"")]" ;
run;

This will format the cell A1 in text format.

 

Indox.

View solution in original post


All Replies
Super User
Super User
Posts: 7,988

Re: text formating Excel cell with dde

Whilst it may be possible, I would really advise that you drop DDE as it has been out of support for well over 10years now, and in some cases doesn't work.  If you need formatting on your output data, consider using one of the newer techqniques such as excelxp/excel in combination with proc report which can give detailed formatted reports.  If you need something in advance of that, then dump your data out to CSV, and then using VBA in Excel open that CSV and process further.

Solution
‎04-12-2017 09:35 AM
Occasional Contributor
Posts: 7

Re: text formating Excel cell with dde

Hello,

 

For those who are in the same situation, here is the solution:

filename xlappli dde "excel|system";
data _null_;
file xlappli;
PUT "[SELECT(""R1C1:R1C1"")]" ;
PUT "[FORMAT.NUMBER(""@"")]" ;
run;

This will format the cell A1 in text format.

 

Indox.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 124 views
  • 0 likes
  • 2 in conversation