Hello,



I'm a VBA novice trying to solve a data processing problem at my law firm internship. I am tech savvy and have some basic programming background, but starting from zero as far as VBA. Would really appreciate any help on this.

The situation:
I have a massive text file that I want to extract certain snippets from into an Excel file.

The doc consists of thousands of entries like this:
NEGATIVE DECLARATION-NG-12-196-PL: ENV-2012-595. 2701 S. Western Ave.; South Los Angeles. Council District No. 10. Conditional Use to permit the addition of off-site sale of beer and wine only to an existing, approx. 3,115 sq. ft. convenience market, and to permit the hours of operation from 7:00 am to 9:00 pm daily, on an approx. 26,200 sq. ft. parcel in the C2-1 Zone. Please call a DAY in advance to review file: (213)978-1332. If no answer, please leave message. Documents are available for review by appointment ONLY at: Los Angeles City Hall, 200 N. Spring St., Rm 750, Los Angeles, CA 90012. Comments can be faxed to: (213)978-1343 or e-mailed to: Darlene.Navarrete@lacity.org. REVIEW/COMMENT period ends: July 25, 2012

I'd like the Excel output to look like this (supposed to look like four columns...FYI forum doesn't render properly):

| STATUS | CODE | PROJECT | PROJECT # |
Negative Declaration NG-12-195 2701 S. WESTERN AVE ENV-2012-595

Is this a good fit for a VBA Macro? Any suggestions would be much appreciated.

-Dan

Cross-posted at: http://www.techsupportforum.com/foru...el-654086.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]