It would help if you post significantly more details. We don't have enough information to help you otherwise. For starters, show the code you're trying and the error you're getting. ... View more

@Kurt_Bremser wrote: And "urgent" in connection with not knowing how to do something points to a massive planning failure in your organization. Maybe if it is that urgent they are willing to pay the $500 per hour this sort of question deserves. ... View more

Fortunately you are not the first one with such a problem, so you will find working code in the web.   If all files have the same structure, you don't need macro code, but wildcards in the infile statement. If you need to identify the files currently being processed, the infile-statemtn has an option for this.     ... View more