Date:         Tue, 7 Dec 2004 10:12:52 -0800
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: Closing particular Excel File from SAS
Comments: To: Saurabh <saurabh.chandra@GMAIL.COM>

Saurabh -

If I'm not mistaken you want this...

   put '[ACTIVATE("filename.xls")]';
   put '[FILE.CLOSE(TRUE)]';

hth

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Saurabh
Sent: Tuesday, December 07, 2004 1:47 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Closing particular Excel File from SAS

Hello All,

I have multiple Excel files open on my system, and I want to close one
particular file from SAS. How can I do this?


The following code saves the last opened Excel file:

data _null_;
file sas2xl;
put '[save.as("c:\Test",6)]';
put '[file.close(false)]';
run;

Regards,
Saurabh