Issues to run the macro

[SH_94]

Dear community,

I would like to ask if anyone face any issues when running the macro . As previously when i run it , it works but now when i 

run it, it pop out error as below:

May i know how to fix it normally cz it is weird that before it work but now it does not work.

THank you.

[gabrielvilella · Accepted solution]

Hi, I believe you are trying to read a temporary Excel file. You can check this if the file path starts with ~$. This file gets created when someone has the file opened in Excel. You can close those files or even insert a filter tool before the macro with the expression 

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

[SH_94]

Hi @gabrielvilella ,

May i know why i can't see it via my local file folders but i can see it inside the alteryx?

I have two macro in one flow and is it the filter tool expression need to be put in front of both macro?

Thank you.

[gabrielvilella]

By default, Windows Explorer does not display hidden files. If you want to see them you want to enable that option under the View tab