Generating Reports from Text File

[Tom]

I have a log file (ASCII text) from which i have to create a report in MS Excel.

Appreciate any pointers how to achieve this conventionally or otherwise...

Thanks in Anticipation

 

[Tom Ogilvy]

File=>Open and supply the name and path of the logfile

This gets the logfile into excel. It might take you through the text import
wizard - if so, then you might want to turn on the macro recorder before
opening the logfile. the Text import wizard will help you parse out column
oriented information if such is in the log file and the macro recorder will
record the choices you make. Then you can generlize the recorded code and
use it to do subsequent openings of the file using these settings (without
prompt).

After you have the data in the log file, you can process with VBA to
organize it for your report.