Hi,

Can anyone give me some comments or suggestions about
running an FTP command in VBA script. I tried to a macro
in my excel file sending my file directly to my
destination using FTP, here's my code, Why after this code
was performed the next code did not run.

Dim fLOG as string
Dim iBatchCopy as string
Dim cJDay as string
..
..
..
fLOG = App.Path & "\" & "LOG." & cJDay
iBatchCopy = ("cmd /c FTP -s:FTPDATA.DAT 255.255.255.0 " "
" & fLOG)
Call Shell(iBatchCopy, vbHide)
..
..
..
FileCopy myfile, otherfile -- This is not being
performed by vb scripts. WHY?

TIA
Eric