Sas password protect excel file

Regards, Naveen. Posted PM views In reply to naveenraj. How are you intending to do it with X commands? Posted AM views In reply to naveenraj. So: 1. Open the file in Microsoft Excel and specify the password. Open "yourfile. I am getting the attached error. From my point of view the obvious solution is not to use passwords on file level.

It's a crappy security solution. Instead, store the file in a secure location with appropriate access rights. Data never sleeps. Along the lines of saving you password protected file to a restricted access folder without excel passwords, the VBA script below will remove the workbook and worksheet passwords If you have full local SAS you should be able to execute this code from SAS or SAS calling R.

Sheets 1. Range "B1". Range "B2". Newsletter Topics Select minimum 1 topic. Big Data. AndreasAvato November 29, 0 Comments. Sohani Baig Posted November 30, 0 Comments. Go to File-Export data Option and follow the directions. Hope this helps. Register or Login.

Welcome back! In addition, SAS Institute will provide no support for the materials contained herein. This code saves a file generated with the ExcelXP tagset as a native Excel file that is password protected. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for. Search instead for. Did you mean:. All forum topics Previous Next. Import a password protected Excel doc. Posted AM views. Hello, How do I import a password protected Excel document? My proc imports works fine any non-password protected excel doc.