albertan
Member
For full disclosure I posted a similar thread in MrExcel forum:
https://www.mrexcel.com/board/threads/dynamic-source-file-name-change-in-powerquery.1177592/
[FONT="] I appreciate some advice here.[/FONT]
[FONT="]I have a connection with another csv file but its sheet's name changes every day after it gets replaced with a new extracted file. The sheet name is in this format Data20210721 and it keeps changing every day. So next day it will be Data20210722 after a new extract was done (same folder location) and the old extract will be removed.[/FONT]
[FONT="]Is there a way for me to make it dynamic to a source sheet (the file name doesn't change as well as location) which keeps on changing?[/FONT]
https://www.mrexcel.com/board/threads/dynamic-source-file-name-change-in-powerquery.1177592/
[FONT="] I appreciate some advice here.[/FONT]
[FONT="]I have a connection with another csv file but its sheet's name changes every day after it gets replaced with a new extracted file. The sheet name is in this format Data20210721 and it keeps changing every day. So next day it will be Data20210722 after a new extract was done (same folder location) and the old extract will be removed.[/FONT]
[FONT="]Is there a way for me to make it dynamic to a source sheet (the file name doesn't change as well as location) which keeps on changing?[/FONT]