Macro for Password Protected Excel Input Tool

[SH_94]

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

[Luke_C]

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.

[SH_94]

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]

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.