The lazy mans option is to get a telecommunication program that allows
scripting (like Kermit 95). Write and debug the FTP script manually. Then
pick a cell in the spreadsheet and insert a hyperlink to the script file (not
the external server). Clicking the cell will cause the telecom script to
execute and complete the transfer.

From VBA, assuming the link is in A1, the transfer would be accomplished by:

Range("A1").Select
Selection.Hyperlinks(1).Follow

--
Gary's Student


" wrote:

hi
i am doing an application in excel VBA and would like to know
where to get the control for internet transfer. I wanted to use FTP to
connect to an FTP server and get a file to local.
thanks