05-02-2013 11:45 AM
trying to save the excel with password but the session is hungup when I tried
can someone explain me the put statement
Need to know that 1 stands for what how to tweak without creating file without Password and opening it ans saving with password
without that can we do on singel step create password protected file directly?
12-04-2013 08:34 AM
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 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). 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.