Date:         Thu, 28 May 1998 15:01:00 GMT
Reply-To:     kmhall@URAM.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         kmhall@URAM.COM
Organization: Deja News - The Leader in Internet Discussion
Subject:      Re: DDE to Excel under Office 97

In article <6khk90$qcm@sjx-ixn1.ix.netcom.com>,
  "David L. Ward" <warddl@usa.net> wrote:
>
> Excel 97 still accepts Excel 4.0 macro commands.  Unfortunately, DDE is
> unable to pass visual basic commands to Excel.  To accomplish that feat, AF
> is needed.  Good luck!
>
 
In order to have VB commands executed after DDE I used an auto_close macro in
Excel.  Sas is able to close the spreadsheet and then the auto_close macro
will run executing all the vb commands.
 
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading