Date:         Wed, 10 May 2000 13:55:31 +0100
Reply-To:     "Vyverman, Koen" <koen.vyverman@FID-INTL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Vyverman, Koen" <koen.vyverman@FID-INTL.COM>
Subject:      Re: Using SAS to read multiple MS Excel worksheets in one workboo
              k
Comments: To: "dudleyinc@MY-DEJA.COM" <dudleyinc@MY-DEJA.COM>,
          "List SAS-L (E-mail)" <sas-l@uga.cc.uga.edu>
Content-Type: text/plain; charset="iso-8859-1"

Gregory,

You didn't state by what method you are accessing your
Excel data... Assuming you are using DDE to read data
from Excel, you could try the following:

  filename sas2xl dde 'excel|system';
  data _null_;
    file sas2xl;
    .....
    put '[workbook.activate("More Stuff",false)]';
    .....
  run;

Where "More Stuff" is the name of a worksheet in your
Excel workbook container.

Hope this helps,
K.

---------------------------------
Koen Vyverman
Marketing Database Manager
Fidelity Investments - Luxembourg
Phone : (++352) 250 404 22 63
Fax   : (++352) 250 404 22 08
---------------------------------



> -----Original Message-----
> From: dudleyinc@MY-DEJA.COM [mailto:dudleyinc@MY-DEJA.COM]
> Sent: Tuesday, May 09, 2000 5:51 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Using SAS to read multiple MS Excel worksheets in
> one workbook
>
>
> Hello everyone,
>
> Can anyone tell me how to read data from an Excel Workbook which
> contains multiple worksheets.  So far I can read data from an active
> worksheet only, I do not know how to tell Excel to switch to the next
> worksheet.
>
> Thanks for your help,
>
> Gregory.