Date: Tue, 25 Jan 2000 15:23:44 +0000
Reply-To: Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Organization: Crawford Software Consultancy Limited
Subject: Re: Help with macros, excel 97 and SAS 6.12
As David Dickinson <dickinsn@NOSPAM.urrea.org> writes
>I did almost exactly the same thing about three years ago. Mine may not
>have been the most elegant solution, but it worked. Certainly looking at
>it now, I see lots of possibilities for improvements.
>The tricky part (for me, at least) was that excel/sas will not recognize
>filenames for sheets (or areas) made earlier in the same datastep (this now
>seems intuitive, but it took me a while to figure out),
I posted another workaround for this problem some time ago.
The method used FILEVAR= on the file statement.
The dde triplet was provided in a character variable named by FILEVAR=.
It posting should be in the archives.
If it is "lost", let me know and I'll re-post.