Indexing Word documents using Excel via hyperlinks 2

[Mouldheels]

Hi Everyone
I am a passable Excel user but I have a word document issue. However my Word and VBA experience is minimal. If it were COBOL that might be another question

I do not control the design of the word document but I have been asked to index each document with a selection of fields.

The word document is in the form of a table that is filled in with data in the form
Field name : Data for the field.

I think these might be flexifields but since the form is designed by HR I very much doubt that anyone would have the expertise?

I need to extract the contents of some of the data fields and display it as an index in an Excel worksheet.

Any thoughts?

 

[Madawc]

Have you tried Word's own indexing? I picked it up when I needed it, with no previous experience of that aspect of Word.

Try making yourself a test word document. Choose a word. Then Insert > Reference > Index and Tables and so on. Really very easy.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[Mouldheels]

Hi Madawc

Thanks for your quick response.

I have examined the possibilities of "indexing" inside a word document.

I may be using the wrong term.

However what I want to create is a "index" of the contents of lots of word documents

I have this information in the form of a table in a series of word documents. I could copy and paste but that is prone to many errors. If the information has been typed once there is not point in manipluating it in small chunks.

And because I use Excel rather than work I would prefer that for the index although a table in Word would do just as well.

So here are my fields and now what I want is to create the records below them.

Budget Lab Title Manager Phone File Date Post

 

[SkipVought]

I agree with Madawc.

You might find this helpful.

http://www.writersservices.com/wps/s1_wp_index.htm

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Mouldheels]

I would like to thank both of your for your information.

However I must apologise for not making my needs clear in my first post.

Both your answers are excellent for the internal indexing of a document so I have starred you both for your clear replies.

My second post which may have crossed with one of the replies I hope make my issue a little clearer.

 

[SkipVought]

This is a job for...

forum707

I'd repost there and would use VBA, because native Excel just isn't going to cut it for the mass of data/sources that you seem to anticipate, IMNSHO.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]