vba to execute ftp script

[mikeba1]

I have the following ftp script which needs to be executed from a button on a form.
Could you advise as to the vba code to perform this


open ftp.mb.com ' ftp server
contu ' user
reylonieluj89 ' password
!:--- FTP commands below here ---
lcd c:\tinover
cd inbox/uk/psi
binary
mput uk_5.txt
disconnect
bye

 

[PaulF]

I usually put the script into a text file with a .bat extension. I can call the batch file using a ShellAndClose command provided from

Shell32.Bas, Copyright ©1996-97 Karl E. Peterson

PaulF

 

[kjv1611]

Yep, I've used a couple of different methods - basically same thing, different flavors I guess, to run batch files from VBA.

I'd just search on those, and pick out what fits you best.


"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[mikeba1]

Thanks guys