Output password protected multiple files

Question

Hello,

Hope all is well.

I saw multiple macros with the password protected info but when I ran it with issues. I currently have a workflow that generate multiple files based on the Client ID. I need to protect each file with the password that is assigned to each client ID. For this I have a list of the Client ID with the password.

Thanks!

alexnajm · Answer

I think @mabellebautista has the macro - I am suggesting it can be reconfigured to batch and be able to produce multiple files for the multiple clients!

Vinod_Kumar_23 · Answer

Hi, You can download the macro from the link below:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-create-output-password-protected-XLSX-files-in-Alteryx/td-p/891539

and use in your workflow.

alexnajm · Answer

I'm saying you could theoretically build a batch macro to complete this process! Without having your data and/or macros though, I wouldn't be able to replicate on my end.