He'll save the files (each file will always have a differtent name)
He wants to build a marco and run it that imports all the files from his f:\ location. The first one imported will start at A1 and this file could be lord knows how long before hte newt starts to improt. (Maybe finished up at A50 or A500...not real sure) The next file that imports would pick up on the next row after the previous file copied.
Is there a "clean" way to do this?
Here's a copy of the macro.
' ImportDataFiles Macro
With ActiveSheet.QueryTables.Add(Connection:="TEXT;F:\CT_120105_CF.txt", _
.Name = "CT_120105_CF_5"
.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 = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = True