make Word look for xls db files, not doc files?

I

Igor

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?
 
P

Peter Jamieson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Word 97 Password 0
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Automation of scanned file storage based on content 0
Mis-performing MP4 files in Mac PPT 1
Protecting Word 2013 file 1
Word 2013 merge Excel, DDE conncetion path problem 0
Merge documents and datafiles moved to new server 0

Top