Dismiss a dialog box (Via a Macro)

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

Hello Guys
I have written a simlpe macro that invokes text to column after refreshing
data imported fron Access. Is there a way to codify the dismissal of the
dialog box that pops up with do you wish to over- write the existing data or
similar.
I'll be grateful for any help.

Thanks
Kevan
 

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

Macro to launch the Activate dialog box? 2
write a macro to show the edit.find dialog box in excel 1
How to pen the Find dialog box with a macro 2
Delete Blank Rows - specify column via dialog 1
execute a macro from a dialog box on enter 1
Automating key strokes to a dialog box 2
Having a macro interact with a dialog box. 2
Pause in a macro 2

Back
Top