Hi all:
I need to zip excel files, protect with password and share thru mail. Can anyone tell me how to create password protected zip in alteryx?
Thanks,
Tanvir
Ben Moss from the Information Lab created a macro to do exactly that: https://gallery.alteryx.com/#!app/Output-Password-Protected-XLSX/5a9d074e0462d716682045a9
More information and Ben's writeup can be found here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-and-Output-password-protected-XLSX-files-in-Alteryx/td-p/142295
The missing piece in your desired outcome seems to be the dynamic generation of the file name+date. You could either wrap this macro as another macro, or you could adjust the existing macro.
To dynamically pick a latest file and run it through a workflow I like to use this approach: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
If you add a sort tool where you sort by creation date and then a sample tool afterwards where you have it sample the first record before going into the Dynamic Input, you are able to dynamically feed in the latest file every single time the workflow runs.
Hi @BrandonB thanks for your suggestion. i'm not quite sure how to use this. it'd be really helpful if there is any documentation regarding macro configuration?
Hi @BrandonB
This Macro is good , however I found it doesn't work in Alteryx Server.
Can I pls check if you have a server version of the Macro ?
Also, I think it’ll be really good if Alteryx can convert this Macro into a standard tool in the future.
Best Regards,
Gihan
Hello, is there anyway the workflow can be shared in here for the macro that password protects excel files. It seems the links referenced were removed and I have been searching everywhere for a solution. Thanks
Hi Chrisressler - Please find attached the Macro and Workflow.
