Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite
1

I have about 700 Word 2010 documents, each with 10 headings. I have to create an Excel file so that each line in it corresponds to one Word document and each heading of the corresponding document must be in one cell in that line. For example it must look like this:

SU479282 example

Each document only has text and not another things.

I want to create a database from documents such that each heading must be in a separate field but correspond to the relevant Word document. How do I achieve this please?

share|improve this question
2  
well, just so you can start with something, I'll suggest that you try to solve this with excel-vba. You should look into some examples of opening files (filesystemobject), then look how you can identify your headings (possibly by some format-attribute in you word-objects) and to make this performant you'll need multidimensional array, which you can fill inside vba, then copy to your desired excel-cellrange. – Jook Sep 25 '12 at 12:53

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.