Hi Kenneth,
i came across a couple of your posts on FTP using a batch file to download files from an FTP server. I know that you are a celebrated member of this forum and so thought of asking you directly if you know anyway of helping me solve my issue.
Let me summarize my issue:
1] I basically want to logon to an FTP site e.g. ftp: // 123.45.1.21
2] This site has a parent folder say "Job Folder".
3] Under this job folder i have Job number folders say, 2010,2013,2015,2023,2034,2035,2036 etc.
4] Each of these job folders has an excel file with the same name as the job folder e.g. 2010.xls,2013.xls,2015.xls,2023.xls,2034.xls,2035.xls,2036 etc.
What i want to do:
1] Now i want to connect to ftp site.
2] change directory to parent folder.
3] grab sub-folders in an array.
4] loop thru sub-folders - one at a time.
5] download file from sub-folder.
6] open & parse its contents, close it, then upload it back to its sub-folder.
7] end loop.
8] end ftp connection.
Have you worked out anything like this before? I would be most thankful for your assistance.