I'm somewhat of a beginner to SAS and trying to export a password protected Excel file to a location on my network using SAS. I've tried to reference the information in the SAS knowledge base under Sample 31328: Creating password-protected Excel files with SAS® software but I keep getting various errors including "ERROR: Insufficient authorization to access DDE". The errors seem to occur for the steps in the process that are supposed to open Excel. Is there a way to export a password protected Excel file from SAS without having to have the workbook opened? Any help would be greatly appreciated. Thanks.
... View more