Excel input with different tab name each time

Question

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

Capture.PNG

dreldrel · Answer

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.

binu_acs · Answer

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

Excel_Diff_Tab_07122025.yxzp