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 & ""
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 & ""