LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (January 2005, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 26 Jan 2005 23:47:36 -0500
Reply-To:   "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:   Re: DDE excel ACTIVATE command --> error : DDE session not ready and I/O error

I think you are getting two instances of Excel, each with one open document, rather than one instance with two documents.

Launch Excel once, then use DDE to open the files.

On Fri, 21 Jan 2005 05:28:31 -0800, alain.follet@SHAM.FR wrote:

>Hi everybody, > >I have an error with DDE command. When I open 2 excel files on the >server (windows 2003) with the instruction DDE : > >options noxwait noxsync; > >/* Ouverture d'Excel */ >x " 'C:\Program Files\Microsoft Office\Office10\excel.exe' > ""Path\file1.xls"" "; > >x " 'C:\Program Files\Microsoft Office\Office10\excel.exe' > ""Path\file2.xls"" "; > >After this command, the active file is file2.xls. I need to have the >first file, file1.xls to be activated. I have done the following >instructions : > >options noxwait noxsync; > >filename cmds dde 'excel|system'; > >data _null_; > file cmds ; > put '[ACTIVATE("File1.xls")]'; >run; > >But it doesn't work. I have the following message : > >ERROR: DDE session not ready. >FATAL: Unrecoverable I/O error detected in the execution of the data >step program. >Aborted during the EXECUTION phase. > >I have pass this instruction with a long waiting time, so it is not a >time problem. Is someone of you have still saw this error ? > >Tahnk you for your help. > >Alain Follet.


Back to: Top of message | Previous page | Main SAS-L page