02-04-2011, 07:16 PM
Hi,
I need some general advice on the best way to approach programming a macro that does the following:
1. User selects a file from a fixed directory.
2. User selects a FTP Profile from a combo box (popluated by a list of text files, each containing different FTP site info. E.G., Profile1.txt, Profile2.txt etc.)
3. User repeats the above for another file+FTP Profile, and again as needed.
4. Each file is then uploaded using the appropriate FTP site profile, one after another.
---
I can do the programming for the above doing one file at a time, and waiting a long time for each file to upload before starting on the next. Just not sure how to be able to select and queue several files and THEN have them upload in a row/batch to the various selected FTP servers.
Perhaps create a new text file for each file+profile (containing the file name and complete FTP info transfered from the preset Profile) and store in a ToBeUploaded directory, then get each file's info and upload, repeat etc in a For loop?
Any suggestions would be greatly appreciated!
Thanks,
Steve
I need some general advice on the best way to approach programming a macro that does the following:
1. User selects a file from a fixed directory.
2. User selects a FTP Profile from a combo box (popluated by a list of text files, each containing different FTP site info. E.G., Profile1.txt, Profile2.txt etc.)
3. User repeats the above for another file+FTP Profile, and again as needed.
4. Each file is then uploaded using the appropriate FTP site profile, one after another.
---
I can do the programming for the above doing one file at a time, and waiting a long time for each file to upload before starting on the next. Just not sure how to be able to select and queue several files and THEN have them upload in a row/batch to the various selected FTP servers.
Perhaps create a new text file for each file+profile (containing the file name and complete FTP info transfered from the preset Profile) and store in a ToBeUploaded directory, then get each file's info and upload, repeat etc in a For loop?
Any suggestions would be greatly appreciated!
Thanks,
Steve