Date: Thu, 28 May 1998 15:01:00 GMT
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
Organization: Deja News - The Leader in Internet Discussion
Subject: Re: DDE to Excel under Office 97
In article <firstname.lastname@example.org>,
"David L. Ward" <email@example.com> 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