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
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 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.
Thank you!
Do you know why alteryx is creating this ~$ excel file?
Very useful. Thank you Patrick.
Error Message
Macro pointing to a file within the directory
