Getting a macro to answer a dialog box automatically?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top