Excel VBA ---Text File counting
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
|