Ronan, it isn't just double quotes. It has to be 'raw' string encoded... ie with the 'r' in front.
The big problem right now, I suspect is that the path string gets corrupted from the get-go.
any folder that begins with a variety of characters is going to be messed up unless it is raw encoded.. or avoided by fixing your folders or using Herculean effort to correct them.
Did you read the link in my second post?
Filenames and file paths in Python
And to show that it works... change your folder for testing and/or to move you along
location = "C:\Junk"
r"{}\Testsheet.csv".format(location)
'C:\\Junk\\Testsheet.csv'
location = "C:\Junk and space"
r"{}\Testsheet.csv".format(location)
'C:\\Junk and space\\Testsheet.csv'