View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Please help in building a Vba in excel Please help in building a Vba in excel is offline
external usenet poster
 
Posts: 10
Default 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