Change parameter user - Macro to pick up and refresh table

[cristianml]

Hi,

I have a problem when I need to share Power Query workbook on my local PC to another user.  All of the hard coded paths that refer to my local files all have to be rewritten to send the workbook to other user.

How can I solved this, is there any default parameter that can be used so i can avoid rewrite hard coded paths?

Also what I'm looking here is in some how set up a VBA Macro that can pick up the folder to refresh the table already created. Is this possible in Power query ?

Thanks and regads.

[Anonymous · Accepted solution]

You do not really change paths within PowerQuery. Instead, you take advantage of the fact that you can read the current workbook filename and path using the  CELL("filename",B6) function and the standard Data From Table Range. More details can be found in the blog below:

https://www.excelguru.ca/blog/2014/11/26/building-a-parameter-table-for-power-query/