I'm with you; you should be able to do it easily enough. Guess we'll have to
see your code, or at least the outer part of your loop that runs through the
URLs and opens each one in turn.

(Disclaimer: I have done FTP from VBA/Access and VBS, and I don't suppose
VBA/Excel is any different. But I've never done multiple FTP sites in one
VBA session, so I can't swear you're mistaken in principle. Guess we'll find
out.)

--- "CharlieH" wrote:
I've got a routine that a text file from an ftp site, converts it into an
excel spreadsheet, and saves it back to the ftp site. This routine loops
through multiple files and ftp sites. The ftp site paths are listed in a
table and are picked up and defined as variables. Although the routine
succesfully opens the right files from the right sites, it keeps using the
first ftp site for every iteration of the save portion of the routine (like
there's a cache that can't be cleared out or something). I could hard code
the paths, but I like having them in a spreadsheet. Thoughts?