Rose -

A more observant member of SAS-L pointed out to me that you were merging cells in Word not Excel. Although I have limited first hand experience, apparently the process I mentioned is similar. Here's a couple well regarded papers...

http://www2.sas.com/proceedings/sugi24/AppDevel/p26-24.pdf http://www2.sas.com/proceedings/sugi28/016-28.pdf

You can download the Word 95 WordBasic Help File from http://www.microsoft.com/downloads/

I don't have time to explore this further. :(

good luck!

Paul Choate DDS Data Extraction (916) 654-2160

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Choate, Paul@DDS Sent: Wednesday, May 25, 2005 1:22 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: DDE to merge 2 cells across rows?

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