Hi Quentin,
I am using DDE, export data to excel file. Ya, we have installed the same version of MS office. The sample code is below,
* open excel ;
%macro dde_openExcel;
options noxsync noxwait;
filename sas2xl dde 'excel|system'; * reference to open/close excel ;
data _null_;
length fid rc start stop time 8;fid=fopen('sas2xl','s');
if (fid le 0) then do;
rc=system('start excel');
start=datetime();
stop=start+10;
do while (fid le 0);
fid=fopen('sas2xl','s');
time=datetime();
if (time ge stop) then fid=1;end;
end; rc=fclose(fid); run;
%mend dde_openExcel;
%macro dde_makeWorkbook(thepath=,thefile=);
filename sas2xl dde 'excel|system';
filename DDEcmds dde 'excel|system';
data _null_;
file sas2xls;
put '[error(false)]';
put %unquote(%bquote('[save.as("&thepath.\&thefile")]')); * save as ;
run;
%mend dde_makeWorkbook;
While running this macro am getting an error.
Thanks.