Hello Alteryx Community,
I have a workflow that generates four output files with same name. When I run run the workflow, Alteryx combines the outputs into a single workbook with four sheets. I need to add current date in mmddyy format to the workbook name as suffix and password protect it. However I don't want to change the sheet names.
Could someone help me with the Alteryx tool and steps required to add the current date to the workbook and password protect it ?
Any help is much appreciated. Thankyou in advance!
Hi Benjamin,
I use the blob copy macro tool to copy an existing "Template" file. (this file needs to have the password)
The copy will do a copy from the original "template" to the desired file. The output name can be updated with a formatted date value.
Here is a sample:
The call:
The macro:
Hope this helps.