Macro for Password Protected Excel Input Tool

Question

Dear community,

I have downloaded the macro as per the link Password Protected Excel Input Tool - Alteryx Community and would like to ask how we can use the macro if we imported the excel file as per screenshot below:

May i know how should i fill the options for the field file string and field password string as per screesnhow below? I have also attached workflow and excel file for your reference.

The excel file password is alteryx

Read password procted excel.yxmd

password_protected_file.zip

Luke_C · Answer

I'm not familiar with the macro but I'd imagine full path might be the best option. Unsure if you need to add the tab name.

SH_94 · Answer

Hi @Luke_C ,

Thank you for your prompt response

May i know how about File String as per screenshot below: Which options i need to choose?

Thank you.

Luke_C · Answer

Hi @SH_94

If the password is just 'alteryx' then add a formula tool, create a field called password, and just type 'password' as the formula. This field can then be passed to the macro.

Note: For things like this you should export the workflow as a yxzp (Options>Export Workflow) so the macro is included in your attachment.