Unanswered: Import Text Files with Wild Card characters
Each day a computer in the office gets a feed from a remote location. (Text file, pipe delimited) The file names are all the same with the exception of the date at the end of the file name.
I have set up a macro that imports the file when run, but I have to change the file name to match that on the macro first. Is there some way to set up the macro with wild cards so that I can leave the file name the same each time? Would this work to import all text files that meet the criteria, like a batch import?
Not that changing the file name is a huge deal, I am just trying to automate the process so our monkey can do it.