#1
|
|||
|
|||
How to import Word Style Headings and body text into Excel
Hello,
Is it possible to import Headings used in a Word doc to Excel? I am trying to basically "link" a Word doc to Excel by having an Excel document put in all of the Headings used in a Word doc and the text in the body of each Heading. Overall I am trying to achieve the following: 1) Where a user clicks on a link in a Word doc, an Excel doc posted in SharePoint is opened 2) The 2nd Sheet of the Excel Doc displays text "parsed" from the Word doc it was opened from and the information is put into 2 columns: - Column 1 will list all of the section headings used in the word doc (ex. 1.0, 1.01, 1.02, 2.0 etc.) - Column 2 will display the section heading title (ex. Introduction, Overview...) - Column 3 will display the body text of each section (ex. The XYZ application is being created to meet the need of....) 3) On the 1st Sheet of the Excel Doc, the rows in Column 1 contain dropdown boxes listing everying in Column 1 of Sheet 2 4) When a Section Heading is choosen, Column 2 on Sheet 1 will display the associated Heading title and Column 3 will display the body text I don't know how possible this is but I really need to know if it is doable and if so, how to do it. Thanks in advance for any help! Last edited by antztaylor; 11-07-2012 at 10:21 AM. |
#2
|
||||
|
||||
Yes, it's possible, but there would be a lot of programming involved for something that seems to largely replicate Word's own outline function.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Well the purpose of this is to capture feedback from multiple individuals on a requirements document. They don't want to use track changes since there are at least 20 people involved. They would like a way to easily view each requirement number (the heading) and the requirement (the text) in an exported format either using excel or a table within the word doc.
If there is an easier way to do this compared to what I described I would love to know. I am open to ideas! |
#4
|
||||
|
||||
So you don't just want the data for just one document, but for 20, to be collated? Have you considered using Word's 'compare documents' function? That allows you to merge multiple documents in such a way that the differences are highlighted.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Correct, I need a way to allow each person to easily see the requirement, provide their feedback, and their name so that I know who made the comment. I thought excel would be good in order to make it easy for me to keep track of it all especially since the requirement doc is on SharePoint.
|
#6
|
||||
|
||||
Excel might indeed be good, but that doesn't diminish the programming effort required. And I'd question whether the ROI would justify the effort.
If the idea is for the users to suggest changes in the Excel file, I think some of your reviewers will find that rather limiting. Alternatively, if the idea is to collate the changes from 20 reviewers' documents, once you have people changing the wording of headings, re-ordering paragraphs, sentences, etc plus adding/deleting text, simply having 20 versions of the proposal in Excel isn't really going to help much with making sense of it all. Granted, you wouldn't want 20 users' changes being tracked in the one Word document either, which is why I suggested the 'compare documents' function. That way, each review edits just their own copy of the document. Besides, you wouldn't want reviewers undoing each others' changes and getting into arguments about that!
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import multiple text file data into word | mizankabir | Word VBA | 7 | 09-15-2023 10:27 PM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |
Word 2007 Headings: Adjusting Space Between Numbering and Text | rphox2003 | Word | 5 | 08-09-2012 12:27 PM |
Import formatted text from Word into PowerPoint | parboy | PowerPoint | 0 | 07-06-2011 08:52 AM |
Separate body text from TOC heading text | Gordc | Word | 5 | 06-15-2011 04:17 PM |