Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

on818come

Programmer
Oct 6, 2008
22
US
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 :)
 
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.
 
So, just tell me how to merge two cells in EXCEL by DDE
 
So, please just tell me how to merge two cells in EXECL by DDE
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top