I have a macro that brings me the information of a cell X , the macro goes through a list of files and I indicate that I take the value of said cell, but as that file has read key, in the execution of the macro shows me the window requesting the password, I want to avoid having to transcribe the password in each of the files, the "Workbooks.Open Filename:=nombre, Password:=clave" function does not work, because that is to open it, I just need to access, I have the key, I need is to automate this process.
_Thank you ... !!!