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?