Excel file as an input - File name remains same but tab name changes daily

Idyllic_Data_Geek

Hello,

I'm connection to an excel file for input. The excel file refreshes everyday. The file name remains same but the tab names changes daily with the new date. I used the directory and dynamic input tool where I configured it to replace the full path. This approach did not work for me,. Can you please help me in setting this connection so that I don't have to update it daily.

Thanks in advance

Input

Accepted answers

All comments

@Idyllic_Data_Geek one option first extract your tab name using input tool then with the help of a batch macro you can combine all the tab.

Extract_Tab_Dynamically_13_07.yxzp

Idyllic_Data_Geek

There is only one tab in the file. For example todays tab name was refreshed to 'ABC For 13JUL2022'. for yesterday it was 'ABC For 12JUL2022'

@Idyllic_Data_Geek for one tab also it should work

Idyllic_Data_Geek

It should work but is it the best and easiest solution?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703