Dynamic file path

Hello again guys! Well I have been trying to automate a few things that i have to do every day, and it is working great. The only problem is my boss wants it on his computer, but i have static file paths in my code. I know there is a way, just not sure how to do it.

I have my master excel sheet in a folder, along with 2 folders it uses. one folder called Proc it opens up the excel sheets in there, modifies them, then saves them into the Finished folder. So the two folder it uses, is in the same folder as the sheet.

For filepaths, something like:

Please Login or Register  to view this content.