1 Reply Latest reply: May 15, 2014 9:56 AM by RalphB _ RSS

    Open all text files in a folder using VBA

    Metz _

      I'm using VBA in access 97 to dump reports in to another access database. Is there a way to use a wildcard to open all of the text files in the specified folder?

       

      The file names change daily, are named "F[i]mmdd[/i].TXT, and are deleted after processing. Also, on Monday, I process the files from the weekend, so there are 3 files.

       

      Any easy way to do this?