FTP via VBA

H

Himansu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top