This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
For Excel files with passwords, often times either a run command or some sort of R package is used to read in the files. Here is a great link to a previous Alteryx post that uses R to open a file with a password. I bet this can be easily thrown into a batch macro if you would like to read in multiple.