Dynamic source file name change in PowerQuery

albertan

Member
Joined
Nov 9, 2017
Messages
30
Reaction score
0
Points
6
Location
Canada
Excel Version(s)
2013
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=&quot] I appreciate some advice here.[/FONT]
[FONT=&quot]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=&quot]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]
 
On my computer, a .csv file has no spreadsheets, just a file name. So I don't have to consider that the name of the spreadsheet changes daily.
 
Back
Top