copy existing worksheets in Excel from SAS

[tom12122]

Hi,

I have existing Excel file with one worksheet with some graphs. I need to make many copies of this worksheet using SAS and to preserve existing objects.

I thought about calling worksheets.copy VBA command but I somehow can't get it working:

options noxwait noxsync missing=' ' ;

/* Invoke Microsoft Excel. */

X "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE";

data _null_;

rc = sleep(8);

run;

filename sas2xls dde 'excel|system';

data _null_;

file sas2xls;

put "[open(""C:\xls\test2.xls"", 0 , true)]";

put "[Sheets(""Sheet2"").Select]";

put "[Sheets(""Sheet2"").Copy Before:=Sheets(1)]";

run;

Can someone help me?