Analyzing Text file records in VBA without importing into Excel spreadsheet

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
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.
 
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

Importing Text Files Into Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Macro that will insert a simple text string in top cell of text file 1
parsing and importing a text file with records through a VBA macro 2
Date formatting in VBA 1
Import Text file Data into Excel Sheet 3
Importing Word text into Excel 12
Excel VBA help: Text file formatting 19

Back
Top