Controling a dialog box after I've selected the datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JimPNicholls - 16 Dec 2003 15:16 GMT

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.

Reply to this Message

Cindy M -WordMVP- - 18 Dec 2003 17:26 GMT

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)
[quoted text clipped - 4 lines]
>
> 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 :-)

Reply to this Message