HI

i got a piece of code that runs from excel it opens a word document
updates parts of the document then breaks the links between Word and
Excel and then saves it.

I now want to add a table of contents page to the word document. I have
set up the page that I what it to do. I recorded the code and got the
following.
Sub InsertTOC()



' There is a bookmark called "TOC" this line goes to this part of the
document

Selection.Goto What:=wdGoToBookmark, Name:="TOC"
With ActiveDocument.Bookmarks
..DefaultSorting = wdSortByName
..ShowHidden = False
End With
'Then it move to the right of it and then moves down a couple of lines
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeParagraph
Selection.TypeParagraph
Selection.TypeParagraph
Selection.ParagraphFormat.Alignment = wdAlignParagraphLeft
' Insert fields (TOC) onto the page
Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, Text:=
_
"TOC ", PreserveFormatting:=True
End Sub


I copied the code and put it into my Excel VBA and ran it it comes with
Object doesn't support this property or method and highlights the first
line.

any ideas to get this to word?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=530410