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

ActiveWorkbook.SaveAs Filename:= _
/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)


--
jmoffat
------------------------------------------------------------------------
jmoffat's Profile: http://www.excelforum.com/member.php...fo&userid=1151
View this thread: http://www.excelforum.com/showthread...hreadid=378484