Date: Fri, 6 Nov 1998 15:43:26 -0500
Reply-To: "Shumaker, Shawn" <shumakes@BATTELLE.ORG>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: "Shumaker, Shawn" <shumakes@BATTELLE.ORG>
Subject: Re: more DDE to excel
Where do you find the option to record in the old macro language? What
version of Excel?
> -----Original Message-----
> From: Howard Schreier [SMTP:HSchreier@USA.NET]
> Sent: Thursday, November 05, 1998 8:54 AM
> To: SAS-L@VM.MARIST.EDU
> Subject: more DDE to excel
> Try this:
> filename commands dde 'excel|system';
> data _null_;
> file commands;
> put '[PAGE.SETUP(,"&CThe Text of the Footer Goes Here")]';
> Then switch over to Excel and drill down to the footer dialog box. You
> should see the effect.
> I developed this example without consulting a manual or online help.
> Instead, in Excel, I turned on the macro recorder (with the option to
> use the old, pre-VBA macro language) and simply created a footer. Then
> I turned off the recorder and edited the macro. This exposed both the
> name of the function and the fact that the footer text is the second
> argument (notice the one leading comma).
> I find that this reverse engineering approach is often the easiest way
> to research this sort of question.
> This was done with Excel v. 5 and SAS 6.12 TS020 under Win 95.
> > Date: Wed, 4 Nov 1998 10:20:13 -0800
> > From: Kunling Lu <Kunling.Lu@NCAL.KAIPERM.ORG>
> > Subject: more DDE to excel
> > is it possible to DDE to excel header/footer? I need to use the footer
> > easy reading. What possibility to Insert page number in the footer?
> > you for help. -Kunling Lu @Kaiser Permanente