LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default How to use VBA read entries from a Wrod file into Excel

I really really need help on this and andy input would be highly
appreciated:
I am doing a research project and recently got a data file. However,
this data file is in word format and needs to be transformed into excel
for analysis. Each entry of the data file is some basis information
about a company and the file is laid out as follows:

ABC Company
123 Some Rd., East City, CA 76543, 223-345-4567
A local leader in electronics manufacturing

DEF Company
456 Good St., West City, CA 90987, 209-876-7654
Had a new CEO this year and is planning to open an office in LA

GHI Company
789 Lucky St., South City, CA 67887, 321-876-0987
Going to close in 3 months
.......

Btw, all company names are in bold letters.

I believe that there should be a way to work this out with VBA but I am
not familiar with it. I would not mind spending some time to learn it
but it would really help if somebody could give me some leads, like a
template or something.

Many many thanks!

Robin

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you save an excel file to be read as IBM-type text file ? Dee Franklin Excel Worksheet Functions 2 October 10th 06 02:46 AM
excel 2002 -how can you convert a file to a pdf read only file? spunkyf15 Excel Discussion (Misc queries) 4 September 29th 06 09:36 PM
Pasword protected Excel file encrypted, how do I read this file? jonesteam Excel Discussion (Misc queries) 2 December 12th 05 06:32 PM
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. Tim Marsden Charts and Charting in Excel 2 October 15th 05 02:10 PM
Excel file won't open because it' a read only file when it is not IanB Excel Discussion (Misc queries) 1 September 12th 05 01:28 PM


All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"