Help with saveas ftp file problem

[jmoffat]

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)

 

[keepITcool]

2 things:

it's vb not java: dont use + as concatenation but &

more importantly you need to sanitize the filename
and prepare it for urls. replace spaces with %20 etc.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


jmoffat wrote :

 

[jmoffat]

Nope I tried it with full URL encoding and it still fails

 

[keepITcool]

hmmm.

did you read
http://support.microsoft.com/default.aspx?scid=kb;[LN];834489
A security update is available that modifies the default behavior of
Internet Explorer for handling user information in HTTP and in HTTPS
URLs


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


jmoffat wrote :