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

http://www.codeguru.com/vb/links/comments/425.shtml


"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

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

If you're handy with DOS you can create a batch file using the DOS FTP
commands:

http://www.computerhope.com/software/ftp.htm

and use the vba Shell command to launch the batch file.

HTH,
Shockley



"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