Excel input with different tab name each time

[Ariz]

hi all

Hope you are well, would it be possible to link excel input tab where tab name changes slightly each time we get data please ?

Please see the attached picture-in the attached we get excel with tab name "Dataset_12345", each time only number changes but Dataset word stays static

Thanks in advance

Ariz

[binu_acs]

@Ariz you can achieve this with the  help of a batch macro

[dreldrel]

Hi, you can achieve this by using the formula tool along with the dynamic Input tool. Firstly, you need to create the file path in the Formula tool, where you can also specify the tab names. Then pass that generated path into the Dynamic Input tool to read your file.