Unable to open archive for unzipping

[kamwl]

My workflow has worked in the past but this time when i tried to run it i got this message about my excel file compilation macro.

 Error MessageMacro pointing to a file within the directory

[patrick_digan · Accepted solution]

Since the file path starts with ~$, I presume that's a temporary excel file that you don't want to/can't read in. Right after your directory tool, I would apply a filter with this expression:

!StartsWith([FileName],"~$")

[kamwl]

Thank you!

Do you know why alteryx is creating this ~$ excel file?

[patrick_digan · Accepted solution]

@kamwl Excel is creating those files when someone has it open. It goes away as soon as somebody closes it. Those files are hidden by default, but I was able to see it in windows explorer by going to view and then unchecking the box about hide protected operating system files.

[Sharmila]

Very useful. Thank you Patrick.