sas dde

options noxwait noxsync;
X CALL "C:\Program Files\Microsoft Office\Office12\excel.exe";
filename EXCEL dde "EXCEL|SYSTEM";
filename EXPORT DDE 'EXCEL|Tracking form Shanghai!r16c2:r100c3' notab ;
data _null_ ;
  x=sleep(1);
run;


data _null_;
 file EXCEL ;
 put'[open("D:\temp\Seminar Result Tracking Template.xlsx")]';
run;
data _null_ ;
  x=sleep(1);
run;
data _null_;
 set FINAL_REPORT;
 tab = '09'x;
 file EXPORT;
 put CIF_NUMBER ;
run;
data _null_ ;
  x=sleep(10);
run;
data _null_;
 file EXCEL;
 put '[save.as("D:\Temp\Seminar Result Tracking Final.xlsx")]';
 put '[save()]';
 put'[Close()]';
 put'[Quit()]';
run;
data _null_ ;
  x=sleep(10);
run;
filename EXCEL clear;
filename EXPORT clear;