Issues to run the macro

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.

Developer

Common Use Cases

Data Investigation

Accepted answers

gabrielvilella

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],"~$")

All comments

gabrielvilella

!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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335