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 :

> 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.

[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 :

>
> 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)