PDA

View Full Version : Better way to copy text files to a daily report?



Gingertrees
09-22-2011, 07:23 AM
My co.'s phone system spits out a text file with 3 metrics for each of 5 call routes: position performance, answered calls, summary for routes "widgets" "sales" "rentals" "tech" "service" --> 3x5=15 reports in one text file. I have to copy this into an Excel sheet daily. My current method could be improved:
I copy each report to a relevantly named text file, rinse/repeat 14 times, and I have a macro that opens each of these 15 text files in Excel, then copies to the right places in the daily Excel sheet.

I've attached part of an example text file (saved as .doc in order to be attached here).

I kind of want to ask, "Is there a way to parse out the initial text output into these indiv. text files, based on some search of the text?" But there may be a better, faster way than the clumsy method I've been doing.

Ideas????