Error: Invalid FileFormat: '.000000'; trailing text after the integer

Question

Hi Ladies and Gentlemen,😀

I have this workflow to import some xlsx data. I used a macro so it can allow for input of specific sheet names with different schemas. However, it returned this error message when I have this process in a workflow where other input and data process also exist.

The odd thing is when I moved the same thing out to a new blank workflow, it works with no error.

So I have no idea what is the root cause of this issue and how to fix it. Can anyone help?

This is the setup of the Macro.

JokeFun · Answer

oops~

After digging close to 2 hours, I finally found the root cause, which is in the Macro itself. The 2nd action tool which is to update the file extension was written as: SWITCH(FileGetExt([#1]),"-1",".xlsb","50",".xlsm","56",".xls","8",".xlsx",25)

So now I changed it to SWITCH(FileGetExt([#1]),"-1",".xlsb","50",".xlsm","56",".xls","8",".xlsx","25")

And now the error message is gone.

However, I don't understand why it can work either without the quotation marks in some workflows, but just failed in one particular workflow.