Analyzing Text file records in VBA without importing into Excel spreadsheet

E

ExcelMonkey

How do you analysze data in a text file without importing
it into Excel. Does it have to be pulled directly into an
array in VBA? Or can you analyize the text file itself?

I have a text file. I want to:
1) Identify Number of Fields (i.e. columns)
2) Identify Number of records (i.e. rows)
3) Collect stats on the records by fields (Sum, Average,
Count etc)

However I do not know how to reference the fields and
records in a text file. And since I do not want to pull
this directly into Excel, I can't record the macro either.

Any help would be appreciated.

Thanks in advance.
 
G

Guest

No you do not have to pull the data into Excel. In the help menu look up
Input, FreeFile and Split. That should be a good start, sssuming that you are
reasonably competent with VB... If you are not comfortable with the VB then
you will have to import the file...

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

parsing and importing a text file with records through a VBA macro 2
Macro that will insert a simple text string in top cell of text file 1
Importing Text Files Into Access 1
Date formatting in VBA 1
Excel VBA help: Text file formatting 19
Importing Word text into Excel 12
Importing text file without end-of-line delimiter? 8
Import Text file Data into Excel Sheet 3

Top