Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all
thanks in advance for reading this post-- hope it makes some sense We have a folder which has log files. say folder "LOG" have files "sample.log" and so on.. is there a way to count the number of times a specific text has occured in that sample.log ...for example if there's a word "Load" in the log file.. is theres a way that i can automate this process so that if i input the folder to the VBA it generates the Number of "Load" in that sample.log and Displayes the count in excel sheet at a specified location. if i have many such log files in a same folder , is there a way to count all the "load" text for every single file and place them seperatly for each. Any help would be most appreciated, Thanks Ajay Tummala Paceco Corp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formula for counting text in a certain color? | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
Excel - counting cells containing a text string | Excel Worksheet Functions | |||
Excel VBA - open text file, replace text, save file? | Excel Programming | |||
Open delimited text file to excel without changing data in that file | Excel Programming |