I would like to read password proctected file and i have search around the solution. The solution does not work for me and would like to ask if someone can help me to look at the project file attached below?
I’ve checked your project and the attached files.
I’ve tested them in various possible combinations and what I’ve found is, you need to fill out both Edit Password and Password properties of Excel Application Scope.
Password - is to allow the bot to open the file Edit Password - is to allow the bot to do any changes (in this case Read Range)