VBA code scripts in macro

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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)
Click to expand...
Call Shell(iBatchCopy, vbHide)
..
..
..
FileCopy myfile, otherfile --> This is not being
performed by vb scripts. WHY?

TIA
Eric
 
As far as I know your computer name/IP should be the last in command line.
Can you send me the sample FTPDATA.DAT file and tell me what exactly you
want. I can try it and let you know.

Thanks,
Dharmesh Patel
 
Back
Top