https://communities.sas.com/t5/SAS-Procedures/Using-DDE-to-open-a-password-protected-Spreadsheet/m-p/29306#M6865 Hi,<BR /> <BR /> I have managed to get an answer from another source.<BR /> <BR /> Its coded below for any others you require it.<BR /> <BR /> options noxwait noxsync;<BR /> x '"C:\Program Files\Microsoft Office\Office\EXCEL.EXE"'; <BR /> <BR /> data _null_;<BR /> x=sleep(10);<BR /> run;<BR /> <BR /> filename cmds dde 'excel|system';<BR /> <BR /> data _null_;<BR /> file cmds;<BR /> put '[Open("\\Datal0047\Clientserv\SAS\Devt\daniel\excel\Test1.xls",,,,"'"test123"'")]';<BR /> run; Fri, 08 May 2009 10:11:06 GMT Doyleuk 2009-05-08T10:11:06Z https://communities.sas.com/t5/SAS-Procedures/Using-DDE-to-open-a-password-protected-Spreadsheet/m-p/29305#M6864 Hi,<BR /> <BR /> I am lookin to open a password protected spreadsheet via SAS using DDE.<BR /> <BR /> My code below runs perfect for opening non password protected spreadsheets.<BR /> <BR /> Can anyone please help me amend my code to include the password parameter within my code.<BR /> <BR /> options noxwait noxsync;<BR /> x '"C:\Program Files\Microsoft Office\Office\EXCEL.EXE"'; <BR /> <BR /> data _null_;<BR /> x=sleep(10);<BR /> run;<BR /> <BR /> filename cmds dde 'excel|system';<BR /> <BR /> data _null_;<BR /> file cmds;<BR /> put '[Open("\\Datal0047\Clientserv\SAS\Devt\daniel\excel\Test1.xls")]';<BR /> run; Fri, 08 May 2009 07:56:51 GMT https://communities.sas.com/t5/SAS-Procedures/Using-DDE-to-open-a-password-protected-Spreadsheet/m-p/29305#M6864 Doyleuk 2009-05-08T07:56:51Z https://communities.sas.com/t5/SAS-Procedures/Using-DDE-to-open-a-password-protected-Spreadsheet/m-p/29306#M6865 Hi,<BR /> <BR /> I have managed to get an answer from another source.<BR /> <BR /> Its coded below for any others you require it.<BR /> <BR /> options noxwait noxsync;<BR /> x '"C:\Program Files\Microsoft Office\Office\EXCEL.EXE"'; <BR /> <BR /> data _null_;<BR /> x=sleep(10);<BR /> run;<BR /> <BR /> filename cmds dde 'excel|system';<BR /> <BR /> data _null_;<BR /> file cmds;<BR /> put '[Open("\\Datal0047\Clientserv\SAS\Devt\daniel\excel\Test1.xls",,,,"'"test123"'")]';<BR /> run; Fri, 08 May 2009 10:11:06 GMT https://communities.sas.com/t5/SAS-Procedures/Using-DDE-to-open-a-password-protected-Spreadsheet/m-p/29306#M6865 Doyleuk 2009-05-08T10:11:06Z