Dear All,
I have an Excel Power Query I need to make the Source as dynamic based on the value on MyPN!K2 cell as in the below screenshot

to have this line Source = Excel.Workbook(File.Contents("C:\TEST\MyFile\January2024.xlsm"), null, true), becaming Source = Excel.Workbook(File.Contents(MyPN!K2), null, true),
Any way to do it?
Thanks
I have an Excel Power Query I need to make the Source as dynamic based on the value on MyPN!K2 cell as in the below screenshot
to have this line Source = Excel.Workbook(File.Contents("C:\TEST\MyFile\January2024.xlsm"), null, true), becaming Source = Excel.Workbook(File.Contents(MyPN!K2), null, true),
Any way to do it?
Thanks