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
Comments: To: Howard Schreier <HSchreier@USA.NET>

Where do you find the option to record in the old macro language?  What
version of Excel?
 
Thanks
 
shumakes@battelle.org
 
 
> -----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")]';
>    run;
>
> 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
> text
> for
> > easy reading.   What possibility to Insert page number in the footer?
> Thank
> > you for help.  -Kunling Lu @Kaiser Permanente