Action and Excel / sheet

vincent2mots

Hi experts,

I'm trying to work with Action and Text Box components.

I have two Excel files on my desktop :

• test 2018.xlsx
• test 2019.xlsx

These two files have many sheets but one with the same name : "test"

What I need to do is very simple : when I execute the application, I choose the year and It handle the good file.

I tried with the following formula : "C:\Users\Administrateur\Desktop\test "+[#1]+".xlsx|||`test$`"

Unfortunatly it doesn't work... Do you know which formula I can use?

Best regards,

workflow.PNG

JosephSerpis

Hi @vincent2mots you need to change the configuration slightly on your action tool and select File -Value. I mocked up a workflow as well which I you can change the filepath as well.

Dynamic_Input_230702020.yxwz