FTP Transfers with VBA

[E.Anderegg]

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

 

[Joe Sorrenti]

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

 

[JellyBean]

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

 

[shockley]

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