I have a piece of software that exports a bunch of tables into a single text file. I am reading it into Excel 2007 with the OpenText method.
The problem is that the Cable table includes a column called <Cable Size>, and per the American Wire Gauge standards some cable sizes are things like 2/0 (pronounced "two-aught"). Excel thinks it's a date...
Cable Table Bad.PNG
Cable Table Good.PNG

I used the following recorded macro to pull this column in correctly, defining it as Text, but I really don't want to have to define the other column types AND worse, since there are other table below the cable table, it forces the fifth column of those tables to text as well...

Sub Macro1()
'
' Macro1 Macro
' TextImportTest
'

'
    Workbooks.OpenText Filename:= _
        "C:\Users\nscott\Desktop\2012-268 Power System Study\2012-268 - Verallia - Sapulpa, OK\NEC Evaluation\Verallia 130901-2.txt" _
        , Origin:=437, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
        xlNone, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma _
        :=False, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2 _
        , 1), Array(3, 1), Array(4, 1), Array(5, 2), Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1 _
        ), Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1), Array(14, 1), Array(15, 1)), _
        TrailingMinusNumbers:=True
End Sub
I have attached a sample text file. What do I need to do to limit the area defined as Text to JUST the cable table and JUST the <Cable Size> column?
Thanks!
Verallia 130901-2 - Cable Test.txt