How to write in a merged cell by DDE processing? 1

[on818come]

filename title dde 'excel|[ASAP1.xls]INPUT DATA!r10c4:r10c4' notab lrecl=20000;

data _null_;
file title;
put 'CTD';
run;

But this cell is merged by two closed cells. I've got information like "Can't change part of a merged cell", and there is no answer in related tech document.

Thanks for help

 

[ChrisW75]

Have you tried changing the cell reference to cover both the cells which make up the merge cell? I don't know if that'll help, just a guess.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[on818come]

So, just tell me how to merge two cells in EXCEL by DDE

 

[on818come]

So, please just tell me how to merge two cells in EXECL by DDE

 

[on818come]

Sorry, repeat the reply.
Actually what I wanna know is how to import SAS data to merged cell, very important and not avoidable problem for me
thanks a lot

 

[ChrisW75]

I'm sorry, I don't know. I think Klaz is our resident DDE expert, hopefully he'll come along soon with an answer...

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.