How to read in passworded excel files?

Question

Hi,

I am trying to read in a directory of files. I believe they are not being read in because of the password on each file.

I am using the input data tool to read it. Ie \Alteryx\Community\*.xlsx

They all have the same password.

Is there a way to bypass this?

I am getting unable to open file to read error and assume it is because of the passwords.

davidskaife · Answer

Hi @wonka1234

There is a Custom Macro available on the Gallery that can help you with this - https://community.alteryx.com/t5/Community-Gallery/Password-Protected-Excel-Input-Tool/ta-p/937928