topic Re: Macro variable for opening Excel file with DDE in SAS Programming

Macro variable for opening Excel file with DDE

indox — Fri, 24 Mar 2017 08:55:16 GMT

Hello,

I would like to open dynamically Excel files using DDE and Macro Variables.

This is my code :

FILENAME xlAppli DDE "Excel|System" ;
SYSTASK COMMAND "Start Excel" ;
DATA _NULL_ ;
     CALL SLEEP(3,1) ; 
RUN ;

%let region=bretagne;
data _null_;
file xlAppli;
put '[error(false)]';
put '[open(""C:\Users\Desktop\&region..xls"")]';
run;

But it happens nothing.

Can someone help please?

Thank you.

Re: Macro variable for opening Excel file with DDE

indox — Fri, 24 Mar 2017 09:01:46 GMT

Thanks I found the solution, I had to replace outer single quotes with double quotes :

SYSTASK COMMAND "Start Excel" ;
FILENAME xlAppli DDE "Excel|System" ;
DATA _NULL_ ;
     CALL SLEEP(3,1) ; 
RUN ;

%let region=bretagne;
data _null_;
file xlAppli;
put '[error(false)]';
put "[open(""C:\Users\Desktop\&region..xls"")]";
run;

Thanks!