Let me say the problem is that dde 'excel|system' does not work on my
computer. In my last example, fopen('sas2xl','s') does not work, causing SAS
not responding. Another example,
filename sas2xl dde 'excel|system';
data _null_;
file sas2xl;
put '[error(false)]';
put '[open("c:\mydir1\Myxls.xls")]';
run;

also makes SAS not responding.

I can use x command to start an excel file or x 'start Excel' to start
excel.

Why excel|system can not function on my computer?



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

> On 12/16/09, Tom Quin <tomquin99@gmail.com> wrote:
> > The problem is that, I think, SAS can not successfully send commands to
> > Excel throught filename DDE  'excel|system'.
>
> No, SAS can send commands to EXCEL through DDE but your program is not
> doing that.
>
> > I am not clear where the bug is, Windows, Office Excel, or SAS.
>
> The bug is in your program.
>
> What are you trying to do?
>

On Dec 16, 6:36=A0pm, tomqui...@GMAIL.COM (Tom Quin) wrote:
> Let me say the problem is that dde 'excel|system' does not work on my
> computer. In my last example, fopen('sas2xl','s') does not work, causing =
SAS
> not responding. Another example,
> filename sas2xl dde 'excel|system';
> data _null_;
> file sas2xl;
> put '[error(false)]';
> put '[open("c:\mydir1\Myxls.xls")]';
> run;
>
> also makes SAS not responding.
>
> I can use x command to start an excel file or x 'start Excel' to start
> excel.
>
> Why excel|system can not function on my computer?
>
>
>
> On Wed, Dec 16, 2009 at 6:31 PM, Data _null_; <iebup...@gmail.com> wrote:
> > On 12/16/09, Tom Quin <tomqui...@gmail.com> wrote:
> > > The problem is that, I think, SAS can not successfully send commands =
to
> > > Excel throught filename DDE =A0'excel|system'.
>
> > No, SAS can send commands to EXCEL through DDE but your program is not
> > doing that.
>
> > > I am not clear where the bug is, Windows, Office Excel, or SAS.
>
> > The bug is in your program.
>
> > What are you trying to do?- Hide quoted text -
>
> - Show quoted text -

Why are you using DDE at all? I have been following this thread and I
still don't know why people use DDE, I really don't.

1. It is deprecated.
2. It is slow.
3. It locks Excel, the PC, and the file.
4. It lacks flexibility and support of newer areas.
5. There are better ways to do things that are actually easier.

DDE is like CPM. Great in its time but there are far better
technologies available.

I still don't get why SAS programmers still use DDE. However, I am
open (this is not an incrimination just confusion on my part). Why are
people using DDE?

Alan
http://www.savian.net