Controling a dialog box after I've selected the datasource

[JimPNicholls]

Hi
(Word 97)
(Excel 97)

I'm trying to fully automate a mailmerge from excel but I'm stuck automating a dialog box that appears after I've selected the datasource. (the datasource is in excel).

The dialog box appears after I've selected the datasource. The title is "Microsoft Excel" and I have two options to merge, Entire Spreadsheet and _FilterDatabase.

Does anybody know how I can control this dialog box from excel therefore erasing any user input? I would like to select the entire spreadsheet.

Any clues would be appreciated.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SmltUE5pY2hvbGxz?=,

How did you come up with the OpenDataSource code you're trying to use? Did you use the macro recorder? Could you copy/paste your code into y reply, please?

(Word 97)
(Excel 97)

I'm trying to fully automate a mailmerge from excel but I'm stuck automating a dialog box that appears after I've selected the datasource. (the datasource is in excel).

The dialog box appears after I've selected the datasource. The title is "Microsoft Excel" and I have two options to merge, Entire Spreadsheet and _FilterDatabase.

Does anybody know how I can control this dialog box from excel therefore erasing any user input? I would like to select the entire spreadsheet.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail