Can stata read an Excel file that is password protected?
Thank you.
Thank you.
-
Login or Register
- Log in with
- You are not logged in. You can browse but not post. Login or Register by clicking 'Login or Register' at the top-right of this page. For more information on Statalist, see the FAQ.
-
-
Good question. To the best of my knowledge, the answer is no. I've certainly tried everything I could think of to solve this problem and never succeeded. If somebody else out there knows a way to do this, I do hope he or she will respond. What I've always had to do in the past is make a copy of the password protected spreadsheet file and then, in Excel, remove the password from it (which, of course, requires knowing the password). I then import that into Stata.
Comment