Output Password Protected XLSX macro with dynamically changing name (today's date)

Hi everyone,

As a new user who found no password protection/encryption for outputs a little disappointing, I was quite pleased to find this macro by Ben Moss that can apply a password to your xlsx output.

Question for you, how would I deal with a file name that changes based on today's date?

I output an xlsx file with today's date in the name. For example, my current file name defined in the macro question is "test", but I need it to match what is dynamically generated by the output tool in the previous step, for example "test - 2020-11-20" today.

How can I feed that dynamically changing name into the macro?

See example workflow.

Thank you

Password protection test.yxmd

Workflow

Gallery

Output

Macros

Dynamic Processing

Accepted answers

AkimasaKajitani

Hi @DigitalPlumberDave

I recommend when you upload the workflow that contain any macros, you might export "yxzp" file by "Export Workflow" and upload it. Because the when anyone download it, he don't have the macro, then the macro is missing(please refer the below image).

Fortunately I have the Output Password Protected XSLX macro.

Back to the original story.

You have to use Batch Macro that overwrite the filename dynamically.

Workflow:

BatchMacro:

The Action tool connected Parameter control overwrites "FilePath".

Please refer attached workflow.

Please reply to me if you have any questions.

My Alteryx designer version is 2020.4, so I overwrite version info of the workflow into 2019.3.

If attached workflow is not work, please tell me.

ProtectedExcelBatchMacro.yxmc

Password protection test_AK.yxmd

All comments

AkimasaKajitani

Hi @DigitalPlumberDave

Fortunately I have the Output Password Protected XSLX macro.

Back to the original story.

You have to use Batch Macro that overwrite the filename dynamically.

Workflow:

BatchMacro:

The Action tool connected Parameter control overwrites "FilePath".

Please refer attached workflow.

Please reply to me if you have any questions.

My Alteryx designer version is 2020.4, so I overwrite version info of the workflow into 2019.3.

If attached workflow is not work, please tell me.

ProtectedExcelBatchMacro.yxmc

Password protection test_AK.yxmd

DigitalPlumberDave

Hi @AkimasaKajitani,

Thank you very much. I got it to work.

As you can see I have a fair bit to learn, so I appreciate your tips and teaching me a bit more about macros. I must admit, that is the part of Alteryx I know the least of.

AlexAung

Hi @AkimasaKajitani, I am getting the below error message when I tried to use your workflow for custom file name. Original file and macro from Ben Moss has no issue. Please help.

Working directory is c:\temp and I downloaded all files to that folder.

AkimasaKajitani

Hi @AlexAung

Can you share the macro setting?

I doubt that the setting "File Name" of macro is wrong from this result "C:\temp\C:\temp\"

FileName field should be set "Subject" field made at the previous formula tool.

ypt

Hi, able to attach the packaged macro as it has broke and the macro cannot be found from the link.

Sharathdhruthi

Hello

I am trying to protect entire sheet instead of just one tab, when I use this macro it runs however "It is protecting and outputting only one sheet which I mentioned in macro configuration. How do I protect entire sheet ? or only specific sheets but still have all the tabs in the output file ?

Thank you in advance!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703