Set default data format to "text" instead of "general"

Hello,
I am currently using VBA code to import multiple .txt and .tab files into excel which bypasses the Import Wizard. Even if I utilize the Import Wizard, I am restricted to one file at a time and have to change each data format field from "general" to "text" which can be very tedious to say the least. I am having another issue with this code importing each header row in the files while I only want one, but will address this in another thread.....As for what I am looking for here.....Simply put..... I would like the following code, or a similar code that does the same thing, to import all fields as "text" not "general".

Please Login or Register  to view this content.

Please find attached example of workbook and source file.... Any assistance in this matter will be greatly appreciated..... Regards.... Delta

hi Delta, change this code block:

Please Login or Register  to view this content.

to this one:

Please Login or Register  to view this content.

Hello again watersev... That’s what I wanted....Is it possible to keep one of the header rows from the imports like you were looking at in my other post? Or am I asking too much? If not I can work with this.....Thanks again for you knowledge, time, and effort….. Regards.....Delta

Please Login or Register  to view this content.

Perfect.....You are awesome watersev......Regards....Delta