Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

LinkBack Thread Tools Display Modes
Old 07-06-2012, 02:56 PM   #1
Join Date: Jul 2012
Posts: 1
dgcarlin is on a distinguished road
Default Extracting text from a Word Doc into Excel


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: 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):

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.

dgcarlin is offline   Reply With Quote
Old 07-06-2012, 05:46 PM   #2
macropod's Avatar
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,137
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold

Cross-posted at:
For cross-posting etiquette, please read:
Paul Edstein
[MS MVP - Word]
macropod is offline   Reply With Quote

extract word to excel

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting information from Image in word Flambo Word 2 05-06-2012 10:43 PM
Extracting Contacts Data from Excel Caesar Outlook 1 05-08-2011 05:54 AM
Need help extracting specific text from one doument to another with macro/VBA. zsmithku Word 1 04-15-2011 03:46 PM
extracting data from Table to text file Anirudh_Dsp Word Tables 1 05-23-2010 07:48 AM
extracting files from oracle10g into excel janejuzz Excel 0 05-18-2009 12:54 AM

All times are GMT -7. The time now is 12:17 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft