topic Re: Need to save excel with password in SAS Programming https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127839#M26097 <HTML><HEAD></HEAD><BODY><P>Thanks Tom, that's a useful reference for the SaveAs method, but I'm more interested in the documentation of the method described in the original post, save.as&nbsp; In case anyone actually cares about this (which I doubt, since further searching suggests that dde has been deprecated in favor of ODS), I was able to figure out (via trial and error, which seems to be the most useful way to figure out how to use SAS) how to get save.as to work in my situation: I was having issues opening the spreadsheet created in Excel 2007 format (.xlsx), but the spreadsheet opened just fine when created in Excel 2003 format (.xls).&nbsp; If you find yourself coming to this post because of similar issues in opening a spreadsheet created via the save.as method, you might find this useful.</P></BODY></HTML> Wed, 04 Dec 2013 13:34:45 GMT ewgrashorn 2013-12-04T13:34:45Z Need to save excel with password https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127836#M26094 <HTML><HEAD></HEAD><BODY><P>trying to save the excel with password but the session is hungup when I tried</P><P></P><P>can someone explain me the put statement</P><P>put '[open(file)]'</P><P>put '[save.as('file',1,'password')]'&nbsp; </P><P>put '[quit]'</P><P></P><P>Need to know that 1 stands for what how to tweak without creating file without Password and opening it ans saving with password&nbsp; </P><P>without that can we do on singel step create password protected file directly?</P></BODY></HTML> Thu, 02 May 2013 15:45:26 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127836#M26094 BobyGadu 2013-05-02T15:45:26Z Re: Need to save excel with password https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127837#M26095 <HTML><HEAD></HEAD><BODY><P>bump; I too would like to know what the options for the save.as command are (or how to find them)</P></BODY></HTML> Tue, 03 Dec 2013 18:48:29 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127837#M26095 ewgrashorn 2013-12-03T18:48:29Z Re: Need to save excel with password https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127838#M26096 <HTML><HEAD></HEAD><BODY><P>I simple google search found this page from Microsoft.</P><P><A href="http://msdn.microsoft.com/en-us/library/office/bb214129(v=office.12).aspx" style="font-size: 10pt; line-height: 1.5em;" title="http://msdn.microsoft.com/en-us/library/office/bb214129(v=office.12).aspx">SaveAs Method [Excel 2007 Developer Reference]</A></P></BODY></HTML> Tue, 03 Dec 2013 22:49:17 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127838#M26096 Tom 2013-12-03T22:49:17Z Re: Need to save excel with password https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127839#M26097 <HTML><HEAD></HEAD><BODY><P>Thanks Tom, that's a useful reference for the SaveAs method, but I'm more interested in the documentation of the method described in the original post, save.as&nbsp; In case anyone actually cares about this (which I doubt, since further searching suggests that dde has been deprecated in favor of ODS), I was able to figure out (via trial and error, which seems to be the most useful way to figure out how to use SAS) how to get save.as to work in my situation: I was having issues opening the spreadsheet created in Excel 2007 format (.xlsx), but the spreadsheet opened just fine when created in Excel 2003 format (.xls).&nbsp; If you find yourself coming to this post because of similar issues in opening a spreadsheet created via the save.as method, you might find this useful.</P></BODY></HTML> Wed, 04 Dec 2013 13:34:45 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127839#M26097 ewgrashorn 2013-12-04T13:34:45Z Re: Need to save excel with password https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127840#M26098 <HTML><HEAD></HEAD><BODY><P>Recommend you google search for "macrofun.hlp".</P></BODY></HTML> Wed, 04 Dec 2013 14:11:41 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127840#M26098 Oleg_L 2013-12-04T14:11:41Z Re: Need to save excel with password https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127841#M26099 <HTML><HEAD></HEAD><BODY><P>I would not bother with DDE. </P><P>This example may be helpful. <A _jive_internal="true" href="https://communities.sas.com/message/128871#128871">https://communities.sas.com/message/128871#128871</A></P></BODY></HTML> Wed, 04 Dec 2013 14:20:06 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-save-excel-with-password/m-p/127841#M26099 data_null__ 2013-12-04T14:20:06Z