text import file vba

I'm trying to create a automated/dynamic Text Import procedure and having trouble filling the array properties (.TextFileColumnDataTypes, .TextFileFixedColumnWidths) with range variables. I've named the ranges as this would be the ideal way to call them from code. Here is the code: Sub...

I have a macro that imports a text file into excel. It works great, but I have one problem. When it imports, all the columns are in the General format. I need the 3rd column to be in Text format because that column has part numbers, and if the part# starts in 0 it removes the zero. Is there a...

I'm importing several small 2 column data files of dates with variations of the following macro: After importing a few rows correctly the macro starts creating new columns and saves the data there. The macro was captured using Data ==> From Text. This import ran ok.

I am relatively new to working in vba so bear with me. I am writing a macro to search a text file for a string "ioelp". Once i find this string i want to read the file until i find the character ";". I would then like to write the whole string to a new text file. I then need to take this...

I got some files that i must import automatically with a code, but they got no extension, they are special files that i manually import using the import data(text mode) then use some formula to extract information. I need them to be imported with a code, so i can continue the code to do...