Date:         Wed, 19 Sep 2001 18:13:36 GMT
Reply-To:     Ace <b.rogers@VIRGIN.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ace <b.rogers@VIRGIN.NET>
Subject:      Re: Excel commands to write to filename cmds dde "excel|system" l
              recl=512?

On 19 Sep 01 15:10:38 GMT, frank.poppe@PWCONS.COM (Frank Poppe) wrote:

>Thanks Nancy,
>but the final application may be circulated to anywhere, so even network
>drives are not general enough.

I've come across this problem too, so have been sticking with Excel
v4.0 macro language for the last few years. You've got the URL for
this now, I take it?

Once you start putting bits of VBA into excel macros, you've
immediately got an additional overhead of maintaining and distributing
them. Most SAS programmers requirements rarely get beyond file
opening, column formatting, unhiding, closing etc. anyway, so I've
always felt the use of VBA macros to be a bit of an overkill.


--
Ace in Basel