Alteryx Designer, Workflow with Macro Error, The entry point is invalid

Question

I have an Alteryx workflow with a macro inside it. The Macro has an error saying The entry point is invalid. I am not sure how to resolve this error. I never renamed the macro. I have also saved this as a packaged workflow and am getting this error. I went to Options, Advanced Options, Workflow Dependencies and only see the shared drive location for the input files. I do not see a workflow dependency for the macro. I do not see an option to add this workflow dependency.

Input_Directory_Files_Workflow.yxmd

union_xlsx.yxmc

Christine_Assaad · Answer

Hi @brperkins2

Will all files have the same sheet called "CB_9022963_MISSED_FEES_TRNSFRS_$"? If yes, you will need to update your macro to exclude this part. See below for configuration.

If you have many different sheets, you will need to design your macro differently so it looks like  the below. Red Macro is similar to yours.

Hope this helps. Cheers!