Hi,

It appears to me that the directory that the file is being saved in is determined by the value of the cell F1 on the ActiveSheet. Can you please tell me what the value in F1 is?

If the value does not include a directory, then change 
wbDest.SaveAs fName, xlCSV
to 
wbDest.SaveAs "C:\etc\Upload\" & fName, xlCSV
If it does, I will need to know what the value is so I can help provide you with a working solution.

I hope this helps