Date:         Tue, 27 Nov 2007 12:59:46 -0500
Reply-To:     Wensui Liu <liuwensui@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Wensui Liu <liuwensui@GMAIL.COM>
Subject:      Re: Export to Specific cell in Excel
Comments: To: Metricsdude <bsj_adams@hotmail.com>
In-Reply-To:  <79982987-3b70-4387-8bc7-348ad5abc9ec@e1g2000hsh.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

go to sugi and search for dde. lots of good papers.
and you can also find 1 or 2 on my blog if you are patient enough.

On Nov 27, 2007 11:17 AM, Metricsdude <bsj_adams@hotmail.com> wrote:
> On 27 Nov, 15:51, liuwen...@GMAIL.COM (Wensui Liu) wrote:
> > what OS are you using?
> > If it is windows, it should be easy with DDE.
> >
> > On Nov 27, 2007 10:33 AM, Metricsdude <bsj_ad...@hotmail.com> wrote:
> >
> >
> >
> >
> >
> > > Hi There,
> >
> > > I am using version 8.2 of SAS and am currently using the ODS output to
> > > export data to excel spreadsheets,, but I am stuck!!  I need to to
> > > export several tables to one spreadsheet comprising of several
> > > worksheets and to specific cells i.e
> >
> > > Export dataset A to Worksheet 1 cell C2
> > > Export dataset B to Worksheet 2 Cell B7
> >
> > > etc
> >
> > > any help would would be appreciated...
> >
> > > ben
> >
> > --
> > ===============================
> > WenSui Liu
> > Statistical Project Manager
> > ChoicePoint Precision Marketing
> > (http://spaces.msn.com/statcompute/blog)
> > ===============================- Hide quoted text -
> >
> > - Show quoted text -
>
> I am using windows XP..   Do you have an example of any code using
> DDE???
>
> Cheers
>



--
===============================
WenSui Liu
Statistical Project Manager
ChoicePoint Precision Marketing
(http://spaces.msn.com/statcompute/blog)
===============================