Posted: 2016-03-21 22:24
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.
"C:\Program Files (x86)\WinSCP\WinSCP.com" /command "open ftp://[[address]]/" "get /[[file]]" "exit"
Location: Prague, Czechia
The problem is probably that you do not specify a target path for the download (the second argument of the
You can post new topics in this forum
And it's free!