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

Here are three links that offers solutions :

The first is a download. Search WebPage for "FTP example".

http://www.erlandsendata.no/english/downloads/tools.php
http://msdn.microsoft.com/library/en...fercontrol.asp
http://www.computerhope.com/software/ftp.htm

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Thu, 25 Sep 2003 23:34:40 +0200, "E.Anderegg"
wrote:

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

For the download side, have a look at this very simple API call:

Private Declare Function URLDownloadToFile Lib "urlmon" Alias _
"URLDownloadToFileA" (ByVal pCaller As Long, ByVal strURL As String, _
ByVal strFileName As String, ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

Usage:

if URLDownloadToFile(0, strFullURL, strLocation, 0, 0) = Then 'successful
download took place

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"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