The solution: 


Restore the C:\Temp folder, this had been deleted (or moved?) resulting in the Macro dropping the file after having no location to put it.