Text file to Excel macro/vba help

[mattyb102]

Hey everybody, so I have been doing a ton of research, but I'm still having trouble writing a macro using vba. This is what I want my macro to do. I would like it to go to a text file in a folder and sort the text file into different tabs in excel. In the text file the far left column of each line starts with either an H,L,N, or C. I would like the macro to sort these lines by those 4 letters, having a different tab in excel for each letter. So there should be 4 tabs, one for each letter. I was hoping I could do this all with a macro button. Any help on what to do or how to go about this would be much appreciated! Thanks!

 

[kpark91]

Get textfile using FSO (File System Object)

Dim objFSO As New FileSystemObject, objFile As Object
Set objFile = objFSO.OpenTextFile(strPath, ForReading, False, TristateTrue)
'Blah Blah'

Read by line,
Determine H,L,N,or C before inputting the lines into the worksheet
Select worksheet to place the data
Place the data.

Loop through all lines until the end of file.