I'm sorry, you said it was "tedious"??
What I meant when I said that I use ftp to list the contents of the folder, then
find the most recent file, then download it, was that I did it PROGRAMATICALLY.
I had VBA create the bat file, execute it, open the log file, read and process
the list, determine the most recent file, create a new bat file, execute it,
then proceed.
I wouldn't call it "tedious" at all. When I used to do that, I wrote it once,
then it ran for almost 3 years before I had to look at the code again because
they changed FTP sites...
I'm concerned that if you call that "tedous" maybe you misunderstood what I
said..