Date:         Wed, 25 May 2005 13:21:53 -0700
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: DDE to merge 2 cells across rows?
Comments: To: Rose Grandy <rgrandy@CORE.COM>

Rose -

While SAS can't write a VBA macro it can execute one with DDE via a excel v4
macro.  You need to first record and store a VBA macro that merges cells and
then use DDE to run it.  See SAS-L or support.sas.com.

Here's a simple example from Nancy Brucken:
http://xrl.us/f77z

filename cmds dde 'excel|system';
data _null_;
    file cmds;
    put '[SELECT("R4C10:R6C12")]';
    put '[RUN("Personal.xls!MyMacro")]';
run;

hth

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Rose
Grandy
Sent: Wednesday, May 25, 2005 11:36 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: DDE to merge 2 cells across rows?

I am trying to use DDE to merge cells in a document created by ODS RTF. I
figured out how to merge cells within a row but I can't figure out how to
merge 2 cells within a column (across rows).  Does anyone know/have any
ideas?

Thanks

Rose