Date:         Tue, 9 Oct 2001 11:37:06 -0700
Reply-To:     "Terjeson, Mark" <TerjeMW@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <TerjeMW@DSHS.WA.GOV>
Subject:      Re: Excel DDE issue
Comments: To: Fred Gehm <fred.x.gehm@HOUSEHOLD.COM>
Content-Type: text/plain; charset=us-ascii

Hi Fred,

This is just a stab in the dark.  I don't
know if this will work for the macro
popup message, but, in many cases
that a popup window stops processing
waiting for user input, the addition of
turning off error messaging before and
then turning it back on afterwards many
times eliminates the nuisance popup.
e.g.

  * ------- CREATE NEW WORKSHEET ------- ;
  data _null_;
    file excelcmd;
    put '[error(false)]';
    put '[new(1)]';
    put '[error(true)]';
  run;

Hope this is helpful,
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
mailto:terjemw@dshs.wa.gov


-----Original Message-----
From: Fred Gehm [mailto:fred.x.gehm@HOUSEHOLD.COM]
Sent: Tuesday, October 09, 2001 11:22 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Excel DDE issue


I'm trying to read a Excel file useing SAS and DDE.  Microssoft gives me a
warning that the spreadsheet of interest contains macros and do I want to
turn them off, yes or no.  I don't care yes or no.  I want to surpress the
message.  Any way to do that?

Bye the bye, thanks to the SAS-L'rs who have been so generious in the
past.  Especially, Rob Workman, William Viergever, Koen Vyerman and Ace.