Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

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

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
Reply With Quote
  #2  
Old 07-06-2012, 05:46 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,669
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
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Tags
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 06:31 AM.


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