Date:         Thu, 28 Sep 2000 15:59:56 -0400
Reply-To:     "Brucken, Nancy" <Nancy.Brucken@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Brucken, Nancy" <Nancy.Brucken@PFIZER.COM>
Subject:      FW: excel4/5 ... was : writing to a different worksheet ..
Content-Type: text/plain; charset="iso-8859-1"

Another solution is to just use the Excel 97 Macro Recorder to record VBA
macros, and then call those macros from SAS using the Excel 4 RUN command.
That approach works well even if you have users running different language
versions of Excel 97 (French, English, etc.), as each language version of
Excel reads and translates VBA appropriately.
      Nancy

Nancy Brucken
Clinical Informatics
Pfizer Global Research & Development, Ann Arbor
(734) 622-5767
E-mail address:  Nancy.Brucken@pfizer.com


-----Original Message-----
From: Terjeson, Mark [mailto:TERJEMW@DSHS.WA.GOV]
Sent: Thursday, September 28, 2000 10:08 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: FW: excel4/5 ... was : writing to a different worksheet ..


FYI

I notice the reference below about using the Macro Recorder
to build the code for you.  Indeed the recordder builds code.
For DDE via SAS it is only suggestive.  The DDE interface
for SAS has not been updated since the "darkages" in Excel
cronology (and won't be if sources are correct).  The Excel
command set for the SAS DDE is a hybrid or cross between
Excel 2.1 macro syntax and Excel 4.0 macro syntax.  Yep,
not method and property like today's Excel syntax.   The
Excel 2.1 macro documentation (paper) is out of print and
Microsoft states that photocopying one (if you can find it)
is fine since it is out of print.  Excel 4.0 macro doc can be
found in an old Help file.  When I need to write DDE out they
both come...

Hope this is helpful,
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
(360) 902-0741
(360) 902-0705 fax
mailto:terjemw@dshs.wa.gov