|Date: ||Fri, 1 Jul 2005 09:16:12 -0400|
|Reply-To: ||"Bross, Dean S" <dean.bross@VA.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Bross, Dean S" <dean.bross@VA.GOV>|
|Subject: ||Re: DDE opening an Excel file problem|
|Content-Type: ||text/plain; charset="us-ascii"|
Try using a character variable to build the DDE command before
putting the final command through DDE.
This is untested. Most was copied from your original routine.
length aaa $ 100 ;
*CHANGE THIS STATEMENT ;
put aaa ;
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Avi
Sent: Friday, July 01, 2005 6:54 AM
Subject: DDE opening an Excel file problem
I have a program that should open an Excel file . For various reasons,
the file name is splitted into 2 parts. The following programs refuses
to open the file as it seems that the PUT satement doen't work well with
the || operator. Could you help?
filename comma1 dde 'excel|system';
%let bbb='test1.xls")]' ;
Thanks a lot