Fixed Width Data Importing

I import data into excel regularly and I am looking for help on an annoying feature of excel.

When importing text and choosing, "Fixed Width", excel tries to decide where to put the "breaks". It is ALWAYS wrong. I then have to remove the "excel suggested breaks" and input my desired "breaks".

Is there a way to set excel to just let me do the work? I would rather have NO breaks "automatically input", as it takes me longer to remove the suggested breaks than it does to put in the breaks I need. (For example, I just got 28 suggested breaks when I needed only 4!)

Here is the code that results from clearing the Previous Month's Data, and importing the new data.

Frankly, I thought of this solution, but couldn't figure out how to "choose the file" while the macro is running.



Sub Import_FMR_Data()
'
' Import_FMR_Data Macro
'

'
Cells.Select
Selection.QueryTable.Delete
Selection.ClearContents
Range("A1").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;D:\My HD Documents\EOM Documents\01 Fiscal 2014\01 COGS Reporting\01 Data Reports\2014_09_28 EOM P12\E170_-_CLASS_REPORT.9282014.txt" _
, Destination:=Range("$A$1"))
.Name = "E170_-_CLASS_REPORT.9282014_1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 437
.TextFileStartRow = 1
.TextFileParseType = xlFixedWidth
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = False
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1)
.TextFileFixedColumnWidths = Array(50, 20, 20, 20)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
End With
End Sub

THANK YOU!!!

You just saved me about an hour a month (assuming 30 seconds per download) and a great deal of frustration! (Worth much more than the 30 seconds!)