import txt files with more than 256 col and other tips
It doesn't solve the problem itself in general, but in my case it works
fine...
My file text is subidived into columns that I can consider forming 4 groups.
I turn on Macro REcorder and then import the text file (Data-import)
choosing the first group of columns.
Then just take a look to the macro recorded and coy it three times.
So I run 4 times the query everytime changing TextFileColumnDataTypes
property by defining which columns to take...
ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;C:\Documents and Settings\elab1.txt _
, Destination:=Range("A1"))
......
....
....
..TextFileColumnDataTypes =Array(...)
I think it's rather a newbie trick, but if I consider I'm working with VBA
only for 3days in my life...it should be more than nothing....:-)
|