Adding Current Date and Password Protection to Workbook with multiple Sheets

BENJAMIN2

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!

Clifford_Coon

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.