Extract File over FTP with Excel Macro

Advertisement

Iceman
Guest

Extract File over FTP with Excel Macro

Hi all,

I'm trying to extract a file over FTP to excel, which then modifies the file and reloads. I'm having issues with the file extraction section. I've written a .bat file that successfully extracts the file, with contents below. However, when I either call the .bat file from Excel (.bat executes, but file not retrieved) or replace that call with...

"Call Shell("C:\Program Files (x86)\WinSCP\WinSCP.com /command " & """open ftp://[[address]]/"" " & """get \[[file]]"" " & """exit""")

... I'm no longer successful. I'm content with either approach (direct from the macro or executing the .bat), but appreciate any suggestions on how to solve this problem.

.bat file:
"C:\Program Files (x86)\WinSCP\WinSCP.com" /command "open ftp://[[address]]/" "get /[[file]]" "exit"

Reply with quote

Advertisement

You can post new topics in this forum