Loading a file using power query that contains a date

[micfoste10]

I need to load a file using power query, I can do this if the name of the file does not change but how do I do it if it contains a date. Example. Filename 20190131

Many thabks ,

Mike

 

[Ron Coderre]

Try this:
- Enter the file path in a cell
example: C:\Documents\my_excel_file.xlsm
- Name that cell FilePath
- Select that cell and....Power_Query.From_Table/Range

That will open the Power Query Editor
- Remove all steps EXCEPT the Source step
- Right-Click on the file path cell...Select: Drill Down
(That will establish the file path as a text value that can be used elsewhere)

In your query
Replace this:

= Excel.Workbook(File.Contents("C:\Documents\my_excel_file.xlsm"), null, true)

With this:

= Excel.Workbook(File.Contents(FilePath), null, true)

Now your query will use the FilePath variable as the file location.

Is that something you can work with?