Windows user as wildcard

[KarelKat]

Hi
I am working on a spreadsheet that queries and imports data from an Excel file shared to DropBox.
How do I change the query to be able to use the spreadsheet on any PC that has the DropBox link instead of only the "admin" PC?

Current query code:
let
Source = Excel.Workbook(File.Contents("C:\Users\admin\Dropbox\Reporting\Time\Export\Filename1.xls"), null, true),
#"ImportedFile1" = Source{[Name="ImportedFile1"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"ImportedFile1"),
in

 

[severynm]

Hi welcome!

I have found this (Get username function in Power Query - The BI Power) which seems to work. I renamed that function GetUserName, so the query code will look something like:

= "C:\Users\" & GetUserName() & ...