Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Answering Pop questions when macro is running
I have a macro which takes 15 min. to run. At various times while the macro
is running a popup box will appear and ask "A file named k:\abc.prn already exits at this location. Do you want to replace it?" Yes No Cancel then another one pops up "Do you want to save the changes......" Yes No Cancel. I have 15 various pop ups which appear. My answers will always be the same for each pop up but how do I automate it so it always answers the questions for me and I don't have to sit and wait to answer each question as they pop up? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Answering Pop questions when macro is running
Put the following before the message box:
Application.DisplayAlerts = False and after the message box: Application.DisplayAlerts = True This will choose the default answer for the message box, so make sure you are setting the default button appropriately. --JP On Oct 5, 12:37*pm, mmiazga wrote: I have a macro which takes 15 min. to run. *At various times while the macro is running a popup box will appear and ask "A file named k:\abc.prn already exits at this location. Do you want to replace it?" Yes No Cancel then another one pops up "Do you want to save the changes......" Yes No Cancel.. *I have 15 various pop ups which appear. *My answers will always be the same for each pop up but how do I automate it so it always answers the questions for me and I don't have to sit and wait to answer each question as they pop up? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Answering Pop questions when macro is running
YOu need to add an opion it the macro at the beginning to use default values
or wait for respnse. Then modify the maco to handle the two options. YO could make an array of answers so you can easily change the options or even get the responses from a file. But the code would have to be modified. there is no easy way of feeding the response automatically into the boxes. "mmiazga" wrote: I have a macro which takes 15 min. to run. At various times while the macro is running a popup box will appear and ask "A file named k:\abc.prn already exits at this location. Do you want to replace it?" Yes No Cancel then another one pops up "Do you want to save the changes......" Yes No Cancel. I have 15 various pop ups which appear. My answers will always be the same for each pop up but how do I automate it so it always answers the questions for me and I don't have to sit and wait to answer each question as they pop up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answering an Excel generated msg box Yes | Excel Programming | |||
Answering Message boxes | Excel Programming | |||
Answering pop-up question | Excel Programming | |||
Answering a question in a cell | Excel Worksheet Functions | |||
Answering InpBox prompt | Excel Discussion (Misc queries) |