Here are the first 4 lines of my code:
The "EdAssist" in the first line is a named range in Excel...this allows the file name to change every month/year.
Within the file, there is a tab (and table) that will also change it's name every month/year. How can I change the 3rd line to be a variable (cell value/named range)?
Power Query:
Filepath=Excel.CurrentWorkbook(){[Name="EdAssist"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(Filepath), null, true),
SLRA_Table = Source{[Item="SLRA_2020",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(SLRA_Table,{{"EE ID", type text},The "EdAssist" in the first line is a named range in Excel...this allows the file name to change every month/year.
Within the file, there is a tab (and table) that will also change it's name every month/year. How can I change the 3rd line to be a variable (cell value/named range)?
