Opening txt files as Excel spreadsheet

[Jonathan123]

I have a text file that contains a load of info. It really is tab delimited. Excel converts it into mult. columns as it assumes that since it is tab delimited that they are mult. fields. I, however, want it all in the 'A' column . WorkBooks.open(fileName.txt) is what I am using to open it.

A long work around is that I can open it as a text file read each line and then add the line to the A column as the value.

Perhaps someone knows how I can tell excel not to brake it up so I can open it directly in excel?
Thanks

 

[Jonathan123]

I just found this function:

Workbooks.OpenText(Filename, Origin, StartRow, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo)

has anyone had any experience using it?

"DataType Optional Variant. Specifies the column format of the data in the file. Can be one of the following XlTextParsingType constants: xlDelimited or xlFixedWidth. The default value is xlDelimited."

I think it is the data type field that I need to flag.

Jonathan123