macro adjustment required - importing file into excel 2007

[mattyk]

Hi

Very new to excel 2007. I have the following piece of code that allows me to import and array the data in excel 2003 but does not work for excel 2007. Does anybody have any ideas?

Application.StatusBar = "Importing 0367 Era.Dat File..."
    
        Workbooks.OpenText Filename:=txtDirectory, Origin:=xlWindows, _
        StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(10 _
        , 1), Array(37, 1), Array(45, 1), Array(64, 1), Array(85, 1), Array(97, 1), Array(101, 1)), _
        TrailingMinusNumbers:=True

Thank you in advance


Matt