Using a variable to identify a path in Power Query

[GT Cooper]

I use Power Query at work that references a number of different workbooks. If I want to work at home, I email myself those workbooks. However, the location where those files are stored at home is different from where the files are located at work. How can I use a variable that will adjust the path to the correct location when I work on the files at home, and then readjust the path when I send those files back to the office to work on them? I have some familiarity with VBA and macros, but I am a novice at using them. Thanks