File Not Found In Macro

[SH_94]

Hi Community, 

i have build the workflow and macro as attached below but it prompt me an error message as per screenshot below:

May i know if anyone encounter this before and could you please assist me on this ?

Many thanks in advance

[atcodedog05]

Hi @SH_94 

Can you share the workflow as packaged workflow so that dependencies are not broken.

[SH_94]

Hi @atcodedog05 ,

Many thanks for the reminder.

Please find the attached packages for your reference.

[atcodedog05]

Hi @SH_94 

It seems to work for me. Is this the same input file used ? Are you getting error with this file too?

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Yes..I not sure what happen to my alteryx and it prompt out error message when i open from packages file

Is there anyway to fix the error normally?

Thank you.

[atcodedog05]

Hi @SH_94 

This message is reading file lock. Please close all input files before running workflow.

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Sorry i also just notice that..Basically what is the issue here is i would like to import all the sheet into the alteryx.

As you can see in the result, it only import for the first sheet...This part i not really sure why it does not import second sheet as well.It duplicate the same tab instead of importing the second tab.

Thank you.

[atcodedog05]

Hi @SH_94 

Not sure try this workflow for the task.

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

May i know if the workflow able to accommodate the following scenario:

1. Different sheetname 

2. Different schema for each sheets

Would like to ask, if marco able to read password protected excel file?

Many thanks for the help.

[atcodedog05]

Hi @SH_94 

Answer to the questions

1. Different sheetname? Yes

2. Different schema for each sheets? Yes

3. Would like to ask, if marco able to read password protected excel file? No

Hope this helps : )