Does an application exist to extract a selected point of data from a large number of Microsoft Word files?

Does an application exist that will extract only a selected point of data from a Microsoft Word file?  I need it to do this without opening every one of them all at once.  I just need the data to be extracted, so that I can somehow export it to my destination (maybe as a comma delimited file?) into Microsoft Excel or a similar application.  I thought this would be a lot more productive than opening every single file.


I have hundreds of reports which are mainly made up of text on my drive, but I only need to open each report to get one selected number (our media index) that appears within the same context, same wording on the first page of each report.  It dawned on me that there might be a piece of software out there or an application (or even a tool already at my disposal under XP).


Any info on how to better accomplish this task or on a piece of software would be appreciated.  If not a software, what type of programming might I consider learning in the future that might allow me to accomplish this?  Would Visual Basic be the one?


Would you like to answer or comment?

Sign up for a free account, or sign in (if you're already a member).
  • 626 views
Share Send to a friend Watch Report
 
 

Posted Answers

Order by
 
27 thumbs up

I recommend making a macro. Using macro, you don't need to use any external programming language and it's quite quick to build a new macro.

Macro should:

- open one Word file

- select text you want it to select

- close Word file 

- open Excel file and paste data

- open next Word file

- select text you want it to select

- close Word file

- paste to Excel

and so on. 


Posted 2 years ago ( permalink )
EscApe was invited by Yedda to answer this question.

Rated as
#1 out of 2
0
0

Helpful?

line
line
line



 
69 thumbs up
Track your life @ RecordSage.com

I'm not aware of any particular program to do this, but it could be written relatively easily in VBA, provided you know VBA.  You'd need to write a routine to read through a directory (you'd store all of the docs in that one directory), and for each file open it in word and perform needed search and extraction into another doc or text file or format it as HTML.


Posted 2 years ago ( permalink )
RecordSage was invited by Yedda to answer this question.

Rated as
#2 out of 2
0
0

Helpful?

line
line
line



Sign in to participate

Got an answer for Ecrivaine32? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Sign up for a free account, or sign in (if you're already a member).

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:


Bypass genuine windows xp

How can I really bypass genuine windows xp? all windows programs please...
Submitted by surfer 2 years ago
  • viewed 3423 times

Last answer posted 2 years ago by jaselan


Windows XP - Home or Pro edition?

For the first time ever, I'm finding myself at a need to purchase a legal copy of Windows XP. Up until now, I was using a cracked ...
Submitted by Roee Rotman 2 years ago
  • viewed 809 times

Last answer posted 2 years ago by jaselan


Is a commerical virus protector necessary for ...

Is a commerical virus protector necessary for Windows XP or Vista.
Submitted by lcb 6 months ago
  • viewed 456 times

Last answer posted 5 months ago by rivierabrian



» More...

Explore Related Posts in Forums

Software Development - Developing Database Desktop Applications

to all kinds of programming languages. The problem is that there is a small chance to need to connect to remote MySQL server, because of the needs of the application. I am storing some data in hidden

Data Acquistion software/hardware

I understand that NI is pretty strong in DATA Acquistion software/hardware especially with LABVIEW . Anyone tried using MATLAB as the software for data acquistion ? Heard they have a product xPC

TMG Future Plans on Porting application to current programming technology...

it to a current programming technology? I like the detail very much in TMG but I think the interface is being limited by the technology you are using. I know that moving to another programming
» More...
Powered by
Feed - Subscribe to changes to this Q&A Blog

Explore Related Videos

Diane Garnick Says Fixed Income Makes...

Diane Garnick, investment strategist at Invesco Ltd., talks with Bloomberg's Betty Liu in New York about the U.S. government's financial rescue plan, the outlook for equities and her investment strategy.

NYSE's Niederauer Starting to `See Some...

Duncan Niederauer, chief executive officer of NYSE Euronext, talks with Bloomberg's Cris Valerio in New York about today's volume on the New York Stock Exchange, the lifting of the ban on short-selling of financial stocks, market volatility levels and the outlook for NYSE trading tomorrow. U.S. stocks slid and the Dow Jones Industrial Average fell below 9,000 for the first time since 2003 as higher borrowing costs and slower consumer spending spurred concern carmakers, insurers and energy companies will be the next victims of the credit crisis.

Jim Rogers Prefers G-7 Officials `Do...

Jim Rogers, chairman of Rogers Holdings, talks with Bloomberg's Betty Liu from Singapore about the stock market sell-off, his investment strategy and opposition to government efforts to rescue companies with troubled assets.

Jim Rogers Says Cash Holdings `Gigantic,'...

Jim Rogers, chairman of Rogers Holdings, talks with Bloomberg's Mark Barton from Singapore about the rout in the global financial markets, the response of governments to the crisis and his investment strategy.

Garnick Is `Relieved' to See Wells Fargo...

Diane Garnick, investment strategist at Invesco Ltd., talks with Bloomberg's Carol Massar in New York about Wells Fargo & Co.'s agreement to buy Wachovia Corp. in a transaction valued at $15.1 billion and outlook for the U.S. government's financial rescue plan.

Economic Focus on Inflation, Retail Sales,...

The producer price and consumer price indexes, advanced retail sales data and the latest report on housing starts are among the economic highlights for the week of Oct. 6. Norbert Ore, chairman of the Institute for Supply Management's manufactu