I want to save my excel file onto our server using the save as ftp function:

ActiveWorkbook.SaveAs Filename:= _
"ftp://uname:[email protected]/subdir/" + fname

where fname is some user specified name.

This fails - which on closer inspection would appear to be due to excel placing quotation marks around the filename and so when it tries to save I get an error.

Has anyone found a way around this problem (other than using sendkeys - which works but isn't desireable)