Hello and help
Word 2007, I need to copy a named range from a closed Excel file, then paste
special it as a Paste Link - Microsoft Office Excel Worksheet Object in to
the active Word document.

So far I have the following code which copies the whole Excel sheet ,

Dim FileName As String
FileName = "c:\\Test.688.xls"
FileName = "LINK  Excel.Sheet.12 """ & FileName & """ \a "
Selection.TypeText FileName
Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, Text:= _
       FileName, _
       PreserveFormatting:=True

But I need to restrict this to a named range.
Any ideas or pointers

Thanks