Creating Table of Content ( not heading / subheading )

Hi Gurus,

Using Microsoft Word - VBA, is it possible to create a VBA macro to read from a table and then create a table of content ?

I have tried macro to create Table of Content based on Heading and Subheading and no issue with that. However, I can't get the right when I loop through the table.

Example in my Table

Row 1 - Cell_1, Cell_2, Cell_3
Row 2 - Cell_1, Cell_2, Cell_3
Row 3 - Cell_1, Cell_2, Cell_3

I would like to take the text from Cell_2 and create a table of content.

Row_1-Cell_2 ... page 1
Row_2-Cell_2 ... page 3
Row_3-Cell_2 ... page 3

Can I utilize the Add Method as decribed here ? http://msdn.microsoft.com/en-us/libr.../ff835785.aspx

Any example that you can share ? Thanks.

Originally Posted by macropod

Why would a macro try to read from a table to build a Table of Contents? As I said in your other thread, all you need do is (a) use heading Styles for whatever you want the Table of Contents to contain, then (b) insert a TOC field (e.g. as per the MSDN link) where you want the Table of Contents to appear.

Well, that's the requirement from my user. In the Word document, there are heading 1 and heading 2 which will form the TOC in the first few pages of the document.

Then, there's a table in the middle part of the document that contains some information which the user want it to be indexed in another TOC at the end of the document.

The heading styles you mean is only heading 1 and heading 2 ? or I can create a new heading style myself and ask TOC to generate it for me ?

I found a solution by creating a bookmark in each table cell. However, it is still not a very good way. I would prefer to loop through the table cell and add it manually. However, not able to get the code correct. Sigh ...

Originally Posted by macropod

In that case, you would do better to use a different set of Heading Styles for the table, then create a second Table of Contents that references only those heading levels (making sure also to specify the required heading levels for the first Table of Contents. No need to bookmark anything or to process the table in any particular way.

Actually, I found a simpler solution.
Loop through the table cell, and use Add Bookmark.
Then, go to end of the document and create TOC using Bookmark. Viola !
No need to mess up the heading styles.

Just got to figure out what function to use in the code.
Not too familiar with Word, it is much easier to do it in Excel.

Originally Posted by macropod

That is by no means simpler, and it is far more prone to corruption ...

So, it is not a good approach ? I thought I found a gem but it seems, not the ideal case.

Thanks for your input. Sorry, this is the first time I create Word VBA so kind of new. All the while I am working on Excel VBA and realized that they are 2 different thing.

I'll just create a new style - TOCtable and create another TOC at the end of the article using the this style instead.
The coding also much simpler.