Read a Text File with VBA into Excel

[Mel2016]

I have a huge text file that I want to extract specific data and put each one it into a column in excel. I not even sure how to start. I've only done simple code in excel before.

The data in the text file looks like the following
date. Report name Page number
time

run option:
print option:

class
User Name
________________________

Abcd Joe smith


I only need class and users by class but each class has a different number of users.

Thanks for any help

 

[amdopt]

Have you tried importing the data from the text file and then using the data import wizard?

 

[Mel2016]

Oh yes, tried recording a macro and that got all messed up. My problem is that the class is above the user information and I need it by each userid. So I would have 3 columns in a spreadsheet. But since it's a text file there are so many empty lines I don't know where to start.

 

[amdopt]

Can you attach your text file? Or a link to it?

 

[Mel2016]

How do I attach it?

 

[Mel2016]

Date 11/04/16 User Information Listing Page 1
Time 15:23


RUN OPTION: USER LISTING
PRINT OPTION: NO SYSTEMS


Security Class:


USER NAME
------------------------------ --------------------------------------------------
NT AUTHORITY\SYSTEM
PRODCEAD\ip4567 George Chatty


Security Class: ABSCGEN


USER NAME
------------------------------ --------------------------------------------------
PRODCEAD\GOJOBF GFig
PRODCEAD\MA3593 Sherain Doweary
PRODCEAD\rp7645 Kristin M. Penny
PRODCEAD\tm0477 Kayla Ykins
PRODCEAD\wk1948 Meg Mole
PRODCEAD\iz5555 Lynda Brown


Security Class: ABSIGEN


USER NAME
------------------------------ --------------------------------------------------
PRODCEAD\tn2144 Anne L. Phill
PRODCEAD\jg1353 Kersha Johnsont


Security Class: ADMIN


USER NAME
------------------------------ --------------------------------------------------
PRODCEAD\SYSTEM ADMIN


Security Class: AGACTSSOQ


USER NAME
------------------------------ --------------------------------------------------
PRODCEAD\M0ES27 Nancy Drew
Date 11/04/16 User Information Listing Page 2
Time 15:23


RUN OPTION: USER LISTING
PRINT OPTION: NO SYSTEMS


Security Class: AGACTSSOQ


USER NAME
------------------------------ --------------------------------------------------

 

[Mel2016]

Now this is an example but it did get messed up a bit. the User and Name have space between them