Monday, 15 April 2013

vba - Excel-created FTP bat file not downloading -



vba - Excel-created FTP bat file not downloading -

i have ftp bat file (shown below), not working. when run file through excel, nil happens. likewise, when open straight through ftp.exe, error "'get' not recognized internal or external command, operable programme or batch file." ideas how create function?

open pubftp.spp.org anonymous password lcd c:\users\downloads\ ftp://pubftp.spp.org/markets/rtbm/lmp_by_settlement_loc/2013/11/11/00/rtbm-lmp-sl-201311112300.csv close bye quit

here how calling file within vba:

x = shell("ftp.exe -s:" & ftpfilepath & "" & savename & ".bat", vbhide)

vba batch-file ftp

No comments:

Post a Comment