VB Script for FTP used in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to send a txt file to a remote FTP site, what should be written in the
VB Script? I will create an icon for user to start the sending job.

Please help

Thanks in advance
 
you could use the Shell command to execute the FTP program from the VBA
code. The parameters for the external programme could also be supplied e.g.

result = Shell("C:\windows\ftp .exe 'program commands here ", 0)
 
AFAIK you cannot do this from within VBA. Shell the external programme
would be my choice, especially if you can develop a log on / send script
within the FTP programme, e.g. CuteFTP
 

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

Bypassing Excel's FTP login/password dialog 3
Q On Simple FTP/Telnet 1
Createobject for FTP 2
Excel VB application 4
Multipe file transfer using FTP 1
Refresh Bloomberg data in an excel file from a script 4
Excel Formula help in VB 0
Search Macro or VB script 2

Back
Top