I'm going to be receiving data via FTP to a certain folder that I need to open and append to a holding file (another text file), which I will then import into Excel, parse, reformat and save to yet another text file for import into another application. I don't know how many files are going to be in the designated folder at any given time or what their names are going to be (only that there could be as few as one and they will have a .txt extension). I know how to find and read in a single file name into a variable, but I'm not sure how to do it with multiple files (I suspect I will have to read them into an array or something, but I am not sure how to do this). I also know how to open to text files - 1 as source and 1 as target and append lines from source to target. I have the routine already written to import the "holding" file, reformat and append to the import file and it works with just one text file at a time. I also plan to write a "clean-up" routine to remove the text files once they have been successfully posted. That way, the assumption can be made each time the routine is run that any new text files in the folder will not have already been posted. It's mostly the identifying and reading in the multiple filenames that I need to process that I need help with.
Thanks in advance for any help,
Alan
Thanks in advance for any help,
Alan