I have developed the following code which was working on SAS 9.2, but is now not working on SAS 9.3: x '"C:\Program Files (x86)\Microsoft Office\Office14\excel.exe"'; data _null_; z=sleep(3); *Forces SAS to sleep for 3 seconds while Excel opens; run; filename ddecmds DDE "excel|sheet1!c1c7"; data _null_; file ddecmds; put '[workbook.activate("Sheet1")]'; put '[page.setup("&B&14&""Calibri""Supplemental Kit Evaluation Report (20 Samples)","Page &P",0.25,0.25)]'; put '[insert.picture("\\cpcsrv2\bdm\stats\iC42\Supplemental 20\Programs\ic42 logo6.bmp")]'; put '[format.size(476,80)]'; put '[select("C1")]'; put '[Column.Width(4)]%'; put '[select("C2")]'; put '[Column.Width(12)]%'; put '[select("C3")]'; put '[Column.Width(24)]%'; put '[select("C4:C6")]'; put '[Column.Width(12)]%'; put '[select("C7")]'; put '[Column.Width(13)]%'; run; Any suggestions?
... View more