Excel 2016 3 Txt Files to 3 worksheets in 1 workbook

[DThib]

Hi,

My latest roadblock:

I am trying to pull txt files from a specific location into 3wroksheets so the workbook formulas will do the rest of the work.
I already have the names of the txt files being created to use.
Filenametxt1,

Filenametxt2,

Filenametxt3
And the worksheets are in the workbook.
I would like to pull them with a bit of fuzzy logic. There is a time/date stamp the operators will never get right, but 90% of the name will be called.
This will go to the specified folder to pull the txt file, copy the contents into the appropriate pre-named worksheet, then close the txt files.

Anyone have guidance?_{^{<strike>
</strike>}}​

​

<strike></strike>

 

[DThib]

No one has an answer?
I have the code forthe query table. It worked in the past.
I really need help from the experts here.

What besides:

With ActiveSheet.QueryTables.Add(Connection:="TEXT;" + stub, Destination:=Range("$A$1"))
            .Name = Filenametxt2
            .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 = False
            .TextFileSemicolonDelimiter = False
            .TextFileCommaDelimiter = True
            .TextFileSpaceDelimiter = False
            .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
            .TextFileTrailingMinusNumbers = True
            .Refresh BackgroundQuery:=True

this can I try?
It is the only part of the code I am assembling that is giving me fits.

HELP!!!!!

 

[DThib]

Can anyone help? please....

 

[DThib]

Usually I can get a reply from this, I solved it