Macro variable for opening Excel file with DDE

[indox]

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.

[indox · Accepted solution]

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!