>Terry,
>
>Try it this way:
>
>WITH loMerge.DataSource
>---> .Name = "C:\MyFolder\MySpreadsheet.xls"
> .FirstRecord = 1
> .LastRecord = lnLastrec
> * .LastRecord = 1
>ENDWITH
>
>
>replacing, of course, the value of .Name with the location of your desired spreadsheet file (which you may wish to pass in as another parameter).
Hi Evan,
Thanks for the input. Would still like to know if other
Word 2003 users find that the Data Source is being lost from
their Word DOCs.
Terry :)