Advice on reworking this to work on a MAC operating system

[VBA learner ITG]

Hi Peers,

Need your guidance if possible. I have searched formums and google and cannot find a solution I dont know if this is even possible:

I have the following code which works on a windows operating system. Which was taken from this site:

power-bi/power-query-get-and-transform/power-query-source-from-path-written-in-cell

Is there a way to amend the below to work on a mac?

let Source = Excel.Workbook(File.Contents(Excel.CurrentWorkbook(){[Name = "Path_table"]}[Content][Path_column]{0}),null,true),

 

[RoryA]

As far as I know this still doesn't work on Mac Excel. You can use a parameter with a literal value in it, but not a query based one (you'll get an error about need an on-premises data gateway).