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!