The .Filesearch method was taken out of Excel after Excel 2003. The DIR() method is the one most commonly used now.
Excel cannot change "format" of a text file, it would have to be opened in Excel and during the "open" you would set the parameters for that column B. Turn on the macro recorder and let it record you opening one of those text files, fixing the column format as you import. If you still need to format column B, do that, then save the file back as a text file.
Post all the code that results from that, then we'll take a look.
Bookmarks