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 online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,342
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
Please reply to this thread with any new information or opinions.

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 02:21 PM.


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