macro adjustment required - importing file into excel 2007

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

Please attach the text file so we can test it at our end.

It won't let me upload the file. Not sure if this is against forum rules but if you PM me your email address I can send you both files

Cheers

Matt

You can try zipping the file and then uploading it. Its better you upload the file here so that others too can assist you.

Are you getting any error msg while importing it in 2007?