I have the following Macro....

Can you help me to eliminate the use of any cells on the
import? It comes in all chopped up but I just want it as
the text file is that I am bringing from
Filename:="G:\Gas_Control\EXCEL\DEPT\Y2K\Weaternet
Forecast\cgasdisc.txt

Any HELP would be greatly appreciated.


Sub Text()
'
' Text Macro
' Macro recorded 12/21/2004 by Kreft


Dim destCell As Range
Dim totConspWkbk As Workbook

With Workbooks("DegreeDays.xls").Worksheets("text")
.UsedRange.Clear
Set destCell = .Cells(.Rows.Count, "A").End
(xlUp).Offset(1, 0)
End With

Workbooks.OpenText
Filename:="G:\Gas_Control\EXCEL\DEPT\Y2K\Weaternet
Forecast\cgasdisc.txt", _
Origin:=xlWindows, _
StartRow:=1, DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(8, 1), _
Array(30, 1), Array(41, 1), Array(67, 1), Array
(78, 1))

Set DegreeDays = ActiveWorkbook

ActiveSheet.UsedRange.Copy _
Destination:=destCell

DegreeDays.Close savechanges:=False

Application.Goto destCell, Scroll:=True

ActiveSheet.UsedRange.Columns.AutoFit

End Sub