This statement should work . . .

ActiveWorkbook.SaveAs Filename:="ftp://www.xxxxxxxx.com/pub/test.xls",
FileFormat _
:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False


You'll need to substitute the real site's name in place of the "x's" of
course . . .



"E.Anderegg" wrote in message
...
Hello,
I need for a small project to retrieve a file via ftp from the
internet, process it with Excel an save it back to the FTP site. How
can I do that with vba?? I tried to create a link in Explorer to that
ftp site, but this does not work, so I'm looking for a more
programmatic solution. Any help is much appreciated!!

Ernst