Originally Posted by
mancubus
thank you.
i (somehow) remember some threads with uploaded txt files.
can you open the txt file in excel and save as csv.
then try to upload it.
or maybe one of our members who has access to file sharing sites may download and offer a solution.
mancubus
I tried do self, but got the error
Sub test3()
Dim rowCount AsInteger
rowCount =Sheet1.Range("A"& rows.Count).End(xlUp).Row
rowCount2 =Sheet2.Range("A"& rows.Count).End(xlUp).Row
MsgBox rowCount
MsgBox rowCount2
For i =2To rowCount
For j =2To rowCount2
IfSheet1.Range("H"& i).Value=Sheet2.Range("A"& j).ValueThen
Sheet1.Range("H"& i).Value=Sheet2.Range("B"& j)
EndIf
Next j
Next i
EndSub
error in this string
rowCount2 =Sheet2.Range("A"& rows.Count).End(xlUp).Row
For convenience, I copied all two txt files, and then import the data from the two copies into the Excel worksheet separately. I assume that the data of the copy of the /partdata.txt is imported into the first worksheet, and the 23.txt copy of the data is imported into the second sheet.
why didn't work?
here 24.csv=23.txt , I attached