C
CharlieH
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?
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?