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 |
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 |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com