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;
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;