Solved

Text import from word to excel

Posted on 2013-06-08
1
308 Views
Last Modified: 2013-06-20
Dear experts,

Need a macro which can perform the following

Brief:    In the spreadsheet sheet'outputsheet' in row 1 I have provided the headers, which appear on the word document in several location with in a page
Adjacent to the header title appearing on the word document, there is text which is the field value for the header
Headers are highlighted in the yellow and the value for the record (record here refers to pages) is highlighted in red


So I need a macro which can perform the following

1. Look up the header in the sheet 'outputsheet' row1 and then search for the same in the word document
2. Copy the field value and paste the value in row 2 under the same header
3. Repeat the excercise for every column header as appearing in sheet 'outputsheet'
4. The cells in sheet 'outputsheet' is formatted for wrapp text, hence irrespective of the length of the record the cell should be able to capture the value in the doucment for the header.


Kindly help.
sample-word-to-excel.docx
Sample-word-to-excel.xlsx
0
Comment
Question by:Excellearner
1 Comment
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
Comment Utility
I'm not sure if it is possible. It looks like pure quality OCR text. If you look at your sample, you can find similar, but not same fields:
T yp e  o f t ra de m ark:
and
T yp e  o f t ra de S ark:

May be you can rerecognize this text? Try to use advanced tools like ABBYY Finereader.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now