Hey,
I'm trying to compare multiple excel spreadsheets to one another. In order to open up the spreadsheets, I need to use the directory tool because they're password protected. Is there a way to open multiple password-protected files from the directory and inputting their passwords? I found a solution on this issue when there's one file. The solution used R and it worked fine, but I'm not sure how to do this with multiple files? Please let me know if you can help.
Update:
I've attached a workflow below of me opening one password protected file "mock batch payment February". The password is "Password4". However, this doesn't even seem to be opening anymore. I keep getting a WriteYXDBStreaming() error on the R code. Please let me know if you can help me with these issues.
