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?
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:
filename cmds dde 'excel|system';
DDS Data Extraction
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Rose
Sent: Wednesday, May 25, 2005 11:36 AM
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