Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating Reports from Text File
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generating Reports from Text File
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. -- Regards, Tom Ogilvy "Tom" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating reports from an Excel 2002 worksheet | New Users to Excel | |||
Generating reports with MS Excel 2003 | Excel Discussion (Misc queries) | |||
Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
parsing text file, and generating distinct cell values | Excel Programming | |||
Generating reports | Excel Programming |