Combine password-protected excel files with multiple tabs

Question

Hi, I see there are some R solutions in the community on how to open a single excel that's password-protected, but I'm trying to combine (stacked in rows below each other) multiple excel files that are password-protected. All the files' passwords are the same, but the schema for each file is different. Is this possible, or am I over my head?

Thanks!

alexnajm · Answer

I see this being a batch macro! The R solution would be the main part of the batch macro, and the workflow that contains the macro would feed in the full paths needed. The benefit is that the schema can vary and it will still run - similar to this batch solution: The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten