Excel datasource becomes locked?

[Damon]

Hi,

I am trying to do a mail merge with word using excel as a datasource, I am
doing this via a class module in VB6. When opening the datasource with
MailMerge.OpenDataSource name:=wrdDataDocName it comes up with a "Select
Table" box. I have looked on the Microsoft website and they mention this is
a condition of using Word 2002 because it uses OLEDB instead of DDE, however
they suggest adding "SubType:=wdMergeSubTypeWord2000" to the OpenDataSource
line to force it to use DDE but when I do this the excel datasource says
that it is locked. Does anyone know why this may be happening? Would
appreciate the help.

Thanks

Damon