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"
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"
