FTP download... then FTP delete

[redbull]

I have been googgling for an FTP solution.

I want to automatically connect to a set server, with static usernames and passwords and download the a file name "tempreport.txt"



After the download, I want the program to delete the file from the FTP server.

I am finding bits and pieces of things on the internet, but nothing that handles this type of action directly... If anyone has a module, or a link that can point me in the right direction it is appreciated.

[redbull]

Alright, since posting I have found a way to do this thru command prompt, if I can get those commands working in vba I should be good.

[redbull]

Well I am still lost, Been looking all morning. I can manually connect and do what I need to do in cmd line... but I am unable to get this working... ugh..

[Rawb]

One possible solution would be to:

1. Create a BATCH (or WSH) Script that gets the file via FTP and then renames it to something else when finished.
2. Call that Script from VBA with a check immediately afterwards to see if the renamed file exists.
3. If the renamed file exists, then perform your actions.
4. If the renamed file doesn't exist, then either wait a while and check again or return an error.

[redbull]

Yea I was finally able to resolve it... requires a batch file, then a txt file holding ftp server info... Implementing to code now