Sorry - solved this.

For everyone that wants to know how to refer to a variable within quotations this is the new code I used:

"C:\Users\x\Documents\x\" & Name & ""