Getting a macro to answer a dialog box automatically?

[Guest]

I have a macro which publishes a set of reports to Word once the user has
finished, by running a macro on close of the form used to update.

Each time I get a dialog box that asks me if I want to replace the existing
Word file, which of course I do.

How do I use Send Keys to answer the dialog box, or is there another command
I should be using in the Macro?

Many thanks,

PCX

 

[Ken Snell [MVP]]

You cannot answer a dialog box using a macro... while the dialog box is
displayed, all code and macros are paused and will not run until the dialog
box has been closed.

It may be possible to tell Word to save the files without asking.... post
the macro steps that you're using to do this.