Word Table of Contents from Excel

**BillWilts** · 11-09-2010, 06:31 AM

I am creating an Excel application to write out a Word document based on the contents of various cells. No problem with creating the document and writing the text. But, I'm stuck on creating the table of contents. This code generates the error "Wrong number of arguments or invalid property assignment" but I can't work out what is wrong. Any ideas?

Please Login or Register  to view this content.

**snb** · 11-09-2010, 06:51 AM

This will do the trick:

Please Login or Register  to view this content.

**BillWilts** · 11-09-2010, 07:16 AM

Thanks for the reply. Unfortunately I'm still getting the same error!! It might be because I have references to objects mixed up but in spite of experimenting I'm still no further forward. This is my current piece of code:

Please Login or Register  to view this content.

**snb** · 11-09-2010, 07:49 AM

Be very careful where to place code that supposes a with statement.
You can't add a table of contents to a selection.

Please Login or Register  to view this content.

**BillWilts** · 11-09-2010, 01:01 PM

After much frustrating trial and error I still can't get it to work. The problem seems to be in addressing the ActiveDocument. This piece of code works in a Word document (slightly modified) but not from Excel. Any further thoughts?

**snb** · 11-09-2010, 02:10 PM

Your statement isn't correct.
You'd better not use trial and error, but analyse the code instructionwise. If you know what the code does and why you can effectively adapt it to your wishes.

Please Login or Register  to view this content.

**BillWilts** · 11-11-2010, 04:49 AM

Thanks for your response. I have incorporated that piece of code into the routine that creates the Word document which now works as intended.

**tugaluis** · 04-07-2014, 11:04 AM

hello i have the same problem , is possible to you to show the function me the function?

**arlu1201** · 04-07-2014, 11:55 AM

tugaluis,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.