I don't think so. I think you would have to bypass the normal method
altogether (not even reusing the Open Data Source dialog box) and write your
own VBA Userform to get the file details, then use OpenDataSource to open
the .xls.
--
Peter Jamieson - Word MVP
> Is there a way to have Word 2000 default to look for xls files, not doc
> files, when connecting a merge doc to its database?
Igor - 25 Nov 2003 21:02 GMT
Oh, is that all??? Truly, thanks for the answer. Even when it is "no",
that helps.
>I don't think so. I think you would have to bypass the normal method
>altogether (not even reusing the Open Data Source dialog box) and write your
>own VBA Userform to get the file details, then use OpenDataSource to open
>the .xls.