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