Date:         Fri, 11 Jul 2003 11:20:40 -0400
Reply-To:     Nathaniel_Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nathaniel Wooding <Nathaniel_Wooding@DOM.COM>
Subject:      Re: DDE
Comments: To: David Schwartz <david_schwarz@SRA.COM>
Content-type: text/plain; charset=us-ascii

David

It sounds as if Excel is not opening. Do you actually see an Excel window
appear? Also, what is your operating system.

Nat Wooding



                      David Schwartz
                      <david_schwarz@SR        To:       SAS-L@LISTSERV.UGA.EDU
                      A.COM>                   cc:
                      Sent by: "SAS(r)         Subject:  DDE
                      Discussion"
                      <SAS-L@LISTSERV.U
                      GA.EDU>


                      07/11/03 10:55 AM
                      Please respond to
                      David Schwartz






I have been submitting the following:

  options noxwait noxsync symbolgen mtrace mlogic mprint msglevel=i;
  x  'C:\Progra~1\Micros~1\Office10\excel.exe';

so that I can submit commands to Excel from within SAS as in the following:

   filename cmds dde 'EXCEL|SYSTEM';
   data _null_;
 x = sleep(10);
   run;
   data _null_;
 %let path=c:\report_&st..xls;
 file cmds;
 put "[Save.as(&path)]";
 put "[File.Close()]";
 put '[QUIT()]';
    run;

The result is the following error:

    ERROR: Physical file does not exist, EXCEL|SYSTEM.
    NOTE: The SAS System stopped processing this step because of errors.
    NOTE: DATA statement used:
      real time           0.00 seconds
      cpu time            0.00 seconds

I have checked, and the 'Ignore other applications' box in Excel is not
checked.  Any other ideas on what the problem might be?

DLS