Re: help needed on DDE 'excel|system' #3

  • Follow


I do not find a solution to the problem in this paper.

The problem is that, I think, SAS can not successfully send commands to
Excel throught filename DDE  'excel|system'.

I am not clear where the bug is, Windows, Office Excel, or SAS.

Thanks for responding.

On Wed, Dec 16, 2009 at 4:48 PM, Data _null_; <iebupdte@gmail.com> wrote:

> It looks like you are trying to do something like that described by Roper
> in
> http://www2.sas.com/proceedings/sugi25/25/cc/25p097.pdf
>
> I just tested the program and I works nicely to open EXCEL and wait
> the least amount of time, before continuing.  Then you are ready to
> DDE as you see fit.
>
> On 12/16/09, Tom Smith <tomquin99@gmail.com> wrote:
> > It seems that my system has problem with SAS DDE 'excel|system'.
> >
> > For example,
> >
> > filename sas2xl dde 'excel|system';
> > data _null_;
> >  fid = fopen('sas2xl','s');
> >   rc = fclose(fid);
> > run;
> >
> > SAS just keeps running till Not Responding. Any command/fuction that is
> > put through it to Excel has the same problem.
> >
> > How should I error check my system/SAS to resolve the problem ?
> > Thanks for any hint.
> >
>
0
Reply tomquin99 (72) 12/16/2009 10:54:16 PM


0 Replies
108 Views

(page loaded in 0.04 seconds)


Reply: