FTP Transfers with VBA

  • Thread starter Thread starter E.Anderegg
  • Start date Start date
E

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