microsoft internet transfer control

  • Thread starter Thread starter s99999999s2003
  • Start date Start date
S

s99999999s2003

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
 
Hi,

Have you had any luck? I'm interested in sending a file by FTP.
How did you manage to do that?
 
The lazy man’s 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with FTP commands in Win7+Excel2010 (VBA) 5
Transfer files & change file attributes with VBA ? 1
[DOS FTP] Can't abort data transfer using Ctrl+C or Ctrl+Break 0
using command prompt & FTP 2
Send Files To FTP - Can't use Internet Transfer Control ActiveX 6
How do I start a Process I can then communicate with from VBA 2
Running a Telnet session within Excel VBA 0
ftp ---> VBA 1

Back
Top