Date:         Wed, 29 Oct 2003 13:25:54 -0500
Reply-To:     "Elmaache, Hamani" <Hamani.Elmaache@CCRA-ADRC.GC.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Elmaache, Hamani" <Hamani.Elmaache@CCRA-ADRC.GC.CA>
Subject:      Re: Read Excel file
Comments: To: "A. Jarmak" <ali_jarmak@YAHOO.COM>
Content-Type: text/plain; charset="iso-8859-1"

Hi Jarmak.
I think, you have to open both SAS and your Excel file.
But you can use odbc without openning your Excel file.

The code is:
/*********************************************/
libname xl odbc
 noprompt='dsn=Excel Files;
 dbq=C:\myfile.xls';

proc sql noprint;
 select distinct "xl.'"||trim(memname)||"'n"
        into :xlsheets separated by ' '
  from dictionary.members
  where libname='XL' and index(memname,'$')>0;
 quit;

data myfile;
 set &xlsheets;
 run;
/*********************************************/
With this code you can all the sheets in you excel file.

I hope this can help.
Hamani.

-----Original Message-----
From: A. Jarmak [mailto:ali_jarmak@YAHOO.COM]
Sent: October 29, 2003 1:05 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Read Excel file


Hi ,

Is it possible to read an excel file through DDE without open it ?

Regards...Jarmak