How to Import data from a Text File into Excel 

Codes explained here can be downloaded from the following link xlncad.com/macros-excel/

this vid is great. I'll try to use this as reference to make my attendance sheet.

Following is the answer to a question raised by a viewer in FB The question was, how can I read/extract a sentence written in a 'specific line number' in a text file? If you want to read a sentence from a specific line in a text file, for example, the sentence from line number 3 of a text file called VBA Tutorial.txt in the Drive D, the code will be Dim Temptext As String Open "D:\VBA Tutorial.txt" For Input As 1 Range("C1").Select For i = 1 To 3 Input #1, Temptext Next i ActiveCell.Value = Temptext Close (1) --------------------------------------------------------------------------------- then if you want to return the line number of a specific line in text file called VBA Tutorial.txt in the Drive D, for example, the line number of 'XL n CAD' in a text file called VBA Tutorial.txt Dim lineno As Integer lineno = 1 Open "D:\VBA Tutorial.TXT" For Input As 2 Range("C1").Select Do Until EOF(2) Input #2, Temptext If Temptext = "XL n CAD" Then ActiveCell.Value = lineno End If lineno = lineno + 1 Loop Close (2)

thanks bro

Hi, great video! Simple question, how can I open txt files when they have the same name but at the end of the name has a date instead of a consecutive number?

Hi Sir Can share the coding.

Sir this code my text file data automatically trim but i am not want trim data i am want same format paste in excel

hi Anand, Thank you for the great video. I am a beginner for VBA. I am wondering whether how I can modify this code for my purpose. I have multiple txt files with same format. for example the first 2 files; file1.txt Para1:aaaa Para2: bbbb Para3:cccc file2.txt Para1:dddd Para2: eeee Para3:ffff I need to extract the data into columns in a excel sheet like; Para1 Para2 Para3 aaaa bbbb cccc dddd eeee ffff Highly appreciate if you can assist me to get this Thank you

Sir how to import specific data in require specific cells