Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

LinkBack Thread Tools Display Modes
Old 07-06-2012, 02:56 PM
dgcarlin dgcarlin is offline Windows XP Office 2007
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.

Reply With Quote
Old 07-06-2012, 05:46 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,800
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]
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 04:39 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