FTP via VBA
 

Hello everyone,



I have an Excel VBA macro that basically processes .txt files (runs some
cosmetic touches and aggregate functions).



** Here's the problem: I have to manually import (via ftp gui) the .txt
files from a server onto my desktop then run the macro. Is there any way to
ftp the files via VBA then run the macro. Basically run the macro and
prompt me for the files to import and I pass the parameters. Let me know if
anyone has ever attempted this. Any input will be greatly appreciated.



--

Thanks,

Himansu